Sql Stuff

Ramblings of all kinds of Sql related tasks - usually related to customer questions, problems, etc. (that's what I do and all)

February, 2007

  • Sql Stuff

    What is a hobt_id in Sql 2005?

    • 1 Comments
    The same customer that promted the post of mine titled "How can I get sysindexes information in Sql 2005?" posed a follow-up question - what is the hobt_id column in the sys.partitions catalog view and how does it relate to other catalog views/structures...
  • Sql Stuff

    How can I get sysindexes information in Sql 2005?

    • 1 Comments
    A customer asked me today how they could retrieve information similar to that available in the "sysindexes" system table from Sql Server 2000 in Sql Server 2005 using the new catalog views. Though in Sql 2005 there is a dbo.sysindexes and sys.sysindexes...
  • Sql Stuff

    Row sizes exceeding 8060 bytes in Sql 2005

    • 3 Comments
    A customer I work with questioned me today in regards to hearing that in Sql 2005 you can now have rows that exceed 8060kb in size, the limit of a single row in Sql 2000 (not counting text/blob data). Here's some information on how this works in 2005...
  • Sql Stuff

    SP2 Rollback requires complete reinstallation

    • 1 Comments
    With the releast of SP2 for Sql 2005, a customer asked me today what they need to consider as a rollback plan when applying SP2 to an existing Sql 2005 instance. The answer is outlined in the ReadMe file for the Sql 2005 SP2 release - snipped and pasted...
  • Sql Stuff

    NULL database name values? Database ID of 32,767? What is going on here?

    • 0 Comments
    I had a customer inquire as to why they would see results from queries like the following where the database ID value was null in Sql Server 2005 DMV's: select distinct db_name(database_id) from sys.dm_os_buffer_descriptors b with(nolock); If you change...
  • Sql Stuff

    sys.dm_os_buffer_descriptors aggregations

    • 3 Comments
    Lots of customers I visit are frequently interested in determining what objects/structures/files/etc. are consuming the largest amount of space at a given time (or over time) within the Sql Server buffer pool. In Sql 2000, this was a bit complicated to...
  • Sql Stuff

    How to determine service-related priviledges for Sql Server service account

    • 1 Comments
    I had a customer inquire as to how to verify service-related permissions for the Sql Server service account...i.e., Books Online indicates the Sql Server service account requires permission to start the following related services (amoung many other requirements...
Page 1 of 1 (7 items)