Archive for the 'Performance' Category

Converting OR to Union

• Tuesday, July 5th, 2011

To TOP or not to TOP an EXISTS

• Tuesday, April 5th, 2011

Statistics, row estimations and the ascending date column

• Tuesday, March 22nd, 2011

Are int joins faster than string joins?

• Tuesday, February 15th, 2011

Is a clustered index best for range queries?

• Tuesday, February 1st, 2011

Distincting an IN subquery

• Tuesday, January 18th, 2011

Hit and miss

• Tuesday, July 27th, 2010

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