Archive for the 'Execution Plans' Category

Compiles and recompiles

• Tuesday, August 16th, 2011

Capturing the Execution Plan

• Tuesday, January 4th, 2011

Do IF statements cause recompiles?

• Tuesday, December 14th, 2010

Recompiles

• Thursday, November 18th, 2010

Come and gone

• Tuesday, August 31st, 2010

Hit and miss

• Tuesday, July 27th, 2010

Are trivial plans cached?

• Tuesday, December 8th, 2009

Estimated rows, actual rows and execution count

• Tuesday, September 22nd, 2009

Estimated and Actual execution plan revisited

• Thursday, February 19th, 2009

A Bookmark lookup, by any other name…

• Tuesday, January 27th, 2009