SQL in the Wild » Performance

Archive for the 'Performance' Category

Converting OR to Union

• Tuesday, July 5th, 2011

Posted in Performance, SQL Server, Syndication, T-SQL | 7 Comments »

To TOP or not to TOP an EXISTS

• Tuesday, April 5th, 2011

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

Statistics, row estimations and the ascending date column

• Tuesday, March 22nd, 2011

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

Are int joins faster than string joins?

• Tuesday, February 15th, 2011

Posted in Performance, SQL Server, Syndication | 20 Comments »

Is a clustered index best for range queries?

• Tuesday, February 1st, 2011

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

Distincting an IN subquery

• Tuesday, January 18th, 2011

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

Hit and miss

• Tuesday, July 27th, 2010

Posted in Execution Plans, Performance, SQL Server, Syndication | No Comments »

The Root of all Evil

• Thursday, March 11th, 2010

Posted in Performance, Rants, SQL Server, Syndication | 3 Comments »

The most optimal join type

• Tuesday, November 24th, 2009

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

Multiple Execution Paths

• Tuesday, September 15th, 2009

Posted in Performance, SQL Server, Syndication | 24 Comments »