Browse by Tags

Tagged Content List
  • Blog Post: Watch those clustered indexes

    I had a discussion with a friend in Microsoft IT this morning, and as we were evaluating some query plans we ran into more clustered index woes. Remember that clustered indexes affect the base table itself (which is why there can be only one) and are expensive to update. They are fantastic for reading...
  • Blog Post: 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. You can read more about Statistics here , and in...
  • Blog Post: 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 columns - that is unecessary and could potentially...
Page 1 of 1 (3 items)