Archive for the 'Indexes' Category

SQL University: Advanced Indexing – Indexing Strategies

• Friday, November 11th, 2011

Posted in Indexes, SQL Server, Syndication | 7 Comments »


SQL University: Advanced Indexing – Filtered Indexes

• Wednesday, November 9th, 2011

Posted in Indexes, SQL Server, Syndication | 2 Comments »


SQL University: Advanced indexing – Sorting and Grouping

• Monday, November 7th, 2011

Posted in Indexes, SQL Server, Syndication | 12 Comments »


Indexing for ORs

• Tuesday, May 3rd, 2011

Posted in Indexes, SQL Server, Syndication | 8 Comments »


Is a clustered index best for range queries?

• Tuesday, February 1st, 2011

Posted in Indexes, Performance, SQL Server, Syndication | 9 Comments »


One wide index or multiple narrow indexes?

• Tuesday, September 14th, 2010

Posted in Indexes, SQL Server, Syndication | 19 Comments »


Is a scan a bad thing?

• Wednesday, July 29th, 2009

Posted in Indexes, SQL Server | 10 Comments »


When is a seek actually a scan?

• Thursday, March 5th, 2009

Posted in Indexes, Performance, SQL Server, Syndication | 9 Comments »


All indexes are unique

• Monday, February 9th, 2009

Posted in Indexes, SQL Server, Syndication | 9 Comments »


Index columns, selectivity and inequality predicates

• Friday, February 6th, 2009

Posted in Indexes, SQL Server, Syndication | 10 Comments »


« Previous Entries