Execution plans

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  June 28, 2011 at 1:29 pm

  #1345450

  Difficult question today...

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737757

  More actions

  June 29, 2011 at 10:00 am

  #1346026

  Saw "no" in the article, thought "no", got "no" in the explanation and then ticked the wrong box to mark the correct answer. Some days I think I should have stayed in bed.

  The correct answer has been marked, and points awarded back. My apologies for the typo on my part. I checked the explanation last night and was sure this one was OK.

• Kiara

  SSCarpal Tunnel

  Points: 4185

  More actions

  June 29, 2011 at 10:46 am

  #1346061

  Steve Jones - SSC Editor (6/29/2011)

  ---

  Saw "no" in the article, thought "no", got "no" in the explanation and then ticked the wrong box to mark the correct answer. Some days I think I should have stayed in bed.

  The correct answer has been marked, and points awarded back. My apologies for the typo on my part. I checked the explanation last night and was sure this one was OK.

  Steve, were you intending to post this to *today's* QOTD discussion?

  -Ki

• Paul White

  SSC Guru

  Points: 150468

  More actions

  June 30, 2011 at 5:20 am

  #1346442

  My favourite blog entry on this topic:

  http://blogs.msdn.com/b/sqlprogrammability/archive/2007/01/09/1-0-structure-of-the-plan-cache-and-types-of-cached-objects.aspx

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi

• terrykzncs

  Ten Centuries

  Points: 1324

  More actions

  November 22, 2011 at 12:56 am

  #1411231

  Thanks for the link SQL Kiwi!

  But, is it your favorite?:rolleyes: Am reading through it now....