If you're in the DC/NOVA area (or even some parts of Maryland for that matter), I'll be presenting 2 sessions at the NOVA CodeCamp on April 14th at the Microsoft offices in Reston, VA. My presentations will cover new development features in Sql Server...

Many customers (and non-customers) are often confused about all the different memory configurations and options available on 32bit systems (64bit systems do not have so many considerations thanks to the large flat memory space and a VAS size of 16 terabytes...

A customer this past week was curious how to determine which indexes on their server were being used either very frequently or very infrequently. This type of information can be invaluable when tuning a server on both ends: finding the most frequently...

Earlier this week I had a customer send me the following question: I have a server running the 32-bit edition of SQL 2005 SP1 with 16 GB of memory and 8 CPUs. AWE is enabled and the max server memory setting is 12 GB. When the service is started, memory...

A customer recently questioned me regarding a sorting issue they were having in the following scenario: My database is running under the "SQL_Latin1_General_CP1_CI_AS" Sql collation, but when I run the script below I seem to get incorrect sort results...

A customer this week inquired about auto updating of statistics in Sql 2005, particularly with regards to how and what the new AUTO_UPDATE_STATISTICS_ASYNC option is and how it works...well, here you have it... With Sql Server 2005, the AUTO_UPDATE_STATISTICS_ASYNC...