Sql Stuff

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

March, 2007

  • Sql Stuff

    NOVA Code Camp in DC

    • 0 Comments
    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...
  • Sql Stuff

    PAE and /3GB and AWE oh my...

    • 12 Comments
    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...
  • Sql Stuff

    What indexes are used most often (or least often) on my server?

    • 2 Comments
    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...
  • Sql Stuff

    Sql 2005 Dynamic Memory Managment with AWE enabled

    • 1 Comments
    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...
  • Sql Stuff

    Sorting and comparing unicode and binary data - why do I get a weird sort order?

    • 0 Comments
    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...
  • Sql Stuff

    How does AUTO_UPDATE_STATISTICS_ASYNC work with Sql 2005?

    • 0 Comments
    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...
Page 1 of 1 (6 items)