How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.   Read more...

Find out how to update and tune table statistics in SQL Server to ensure data accuracy and boost performance. Learn auto and manual update commands.  Read more...

Will changing to bulk recovery mode before running DBCC REINDEX help you avoid large log files? András investigates  Read more...

How should you approach indexing your database? Do you have a good strategy for deciding which indicies to create and on which columns? Aaron Ingold brings us a great article discussing these very topics that is likely to become a must read for many DBAs.   Read more...

Sanchan Saxena gets to grips with the new index-tuning tools and features in SQL 2005  Read more...