Tag Archives: indexing

The DBA Team #1–Code and Slides

Posted on March 27, 2013 by way0utwest

Our first DBA Team event, in Richmond, VA just before SQL Saturday #187 went well. Overall I think our experiment was a success and we’re already talking about where and when we might do this again. In the meantime, we … Continue reading →

Posted in Blog | Tagged , , , , , , | 2 Comments

Dropping Indexes

Posted on March 6, 2013 by way0utwest

While working on some demos recently, I needed to drop an index for a test. I executed this generic statement for an index I’d just created. 1: DROP INDEX ix_IndexName Needless to say I was surprised when I got this … Continue reading →

Posted in Blog | Tagged , , , | 3 Comments

Review Your Indexing

Posted on November 26, 2012 by way0utwest

In the latest versions of SQL Server, there are some amazing new features. Many of them allow us to expand the capabilities of SQL Server, but some are added to allow us to dive more deeply into how the system … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Review Your Indexing

Trace Flag 2371 and Statistics

Posted on October 22, 2012 by way0utwest

One of the issues that I see published often on forums like SQLServerCentral is the advice to update statistics on your tables if you have strange performance issues, or sudden changes in performance. Statistics are important for the query optimizer, … Continue reading →

Posted in Blog | Tagged , , | 4 Comments