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...

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...

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...

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...

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...

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...

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...