Archive for the 'Indexes' Category

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 | 7 Comments »


Index columns, selectivity and inequality predicates

• Friday, February 6th, 2009

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


Index columns, selectivity and equality predicates

• Monday, January 19th, 2009

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


Seek or scan?

• Friday, January 9th, 2009

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


What is fragmentation?

• Monday, October 20th, 2008

Posted in Indexes, SQL Server | 8 Comments »


Do wide indexes slow queries down?

• Tuesday, September 23rd, 2008

Posted in Indexes, SQL Server | 9 Comments »


Indexes for aggregates

• Friday, October 19th, 2007

Posted in Indexes, SQL Server | No Comments »