Browse by Tags

• dmv's
• indexes
• partitioning

• Partitioning Data for Query Performance - Where's the benefit?

  I spend a lot of time interfacing with SQL engineers of all types (developers, dba's, architects, ETL engineers, etc.) and something I hear very frequently is "I want to horizontally partition my data to improve my query response times to customers"... Posted Mar 19 2008, 01:08 PM by Chad Boyd with | with 2 comment(s) Filed under: performance tuning, partitioning

• Tracking index maintanence information...

  Similar to my post regarding index usage (most/least often), you can use the following code below to get index operational information (exposed via the sys.dm_db_index_operational_stats dynamic management function in Sql 2005). You can include table filters... Posted Oct 15 2007, 11:26 PM by Chad Boyd with | with no comments Filed under: dmv's, indexes, performance tuning

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

  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... Posted Oct 15 2007, 11:24 PM by Chad Boyd with | with no comments Filed under: dmv's, indexes, performance tuning