Archive for the 'Performance' Category

The Root of all Evil

• Thursday, March 11th, 2010

The most optimal join type

• Tuesday, November 24th, 2009

Multiple Execution Paths

• Tuesday, September 15th, 2009

Functions, IO statistics and the Execution plan

• Wednesday, April 29th, 2009

Catch-all queries

• Thursday, March 19th, 2009

When is a seek actually a scan?

• Thursday, March 5th, 2009

Identifying inaccurate statistics

• Thursday, November 13th, 2008

What are statistics and why do we need them?

• Tuesday, November 4th, 2008

Deadlock Graphs

• Tuesday, September 16th, 2008

Comparing date truncations

• Thursday, September 4th, 2008