February 2007 - Posts

• What is a hobt_id in Sql 2005?

  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? Read More... Posted Saturday, February 24, 2007 6:05 PM by boydc7 | 1 Comments

• How can I get sysindexes information in Sql 2005?

  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 Read More... Posted Saturday, February 24, 2007 5:57 PM by boydc7 | 1 Comments

• Row sizes exceeding 8060 bytes in Sql 2005

  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... Read More... Posted Saturday, February 24, 2007 5:55 PM by boydc7 | 3 Comments

• SP2 Rollback requires complete reinstallation

  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 Read More... Posted Wednesday, February 21, 2007 3:58 PM by boydc7 | 1 Comments

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

  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 Read More... Posted Friday, February 02, 2007 3:36 PM by boydc7 | 0 Comments

• sys.dm_os_buffer_descriptors aggregations

  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 Read More... Posted Friday, February 02, 2007 3:33 PM by boydc7 | 3 Comments

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

  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): Read More... Posted Friday, February 02, 2007 3:32 PM by boydc7 | 1 Comments