Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Indexes
Tuesday, August 18, 2009 7:32 AM

SQL Server Best Practices: Auto-Create and Auto-Update Statistics Should Be On - Most of the Time

SQL Server uses something called the "Query Optimizer" to find the data you're looking for. To do that, there is another mechanism, called "Statistics", which can be created and maintained on columns in a table - even tables that don't have an Index.
Posted by Buck Woody | 3 Comments
Tuesday, August 21, 2007 10:32 AM

Index Overlaps

There are a lot of tools in SQL Server 2005 that will help you with indexes, from enhanced plan diagrams to the Database Tuning Advisor. But I was scouting around this morning for a script that would find places where I had indexes that included duplicate
Posted by Buck Woody | 0 Comments
 
Page view tracker