Archive for the 'SQL Server' Category

Are int joins faster than string joins?

• Tuesday, February 15th, 2011

Quest Webcast: Dos and Don’ts of Database corruption

• Monday, February 14th, 2011

Is a clustered index best for range queries?

• Tuesday, February 1st, 2011

Distincting an IN subquery

• Tuesday, January 18th, 2011

Capturing the Execution Plan

• Tuesday, January 4th, 2011

Do IF statements cause recompiles?

• Tuesday, December 14th, 2010

Recompiles

• Thursday, November 18th, 2010

First Impressions

• Tuesday, November 9th, 2010

A Trio of Table Variables

• Tuesday, October 12th, 2010

One wide index or multiple narrow indexes?

• Tuesday, September 14th, 2010