Temp Tables revisited

Question

Post reply

Temp Tables revisited

Viewing 11 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply

Mike Is Here Hall of Fame Points: 3348 More actions · Answer 1

I really didn't care for this question, you must fix all errors regardless of the order they appear.

I selected the wrong answer with the User error, which was half right.

Paul White SSC Guru Points: 150467 More actions · Answer 2

sharath.chalamgari (6/24/2013)
http://support.microsoft.com/kb/295305

The author should have included that reference in the explanation instead of guessing at how parsing works (and getting it wrong).

Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi

Ken SSCoach Points: 17191 More actions · Answer 3

Nice discussion even if the original explanation was a bit flawed. Thanks for the question Sergiy.

Christian Buettner-167247 SSChampion Points: 13729 More actions · Answer 4

Hugo Kornelis (6/24/2013)
[...]Thanks for putting me straight! 😉

Wow, give me a minute - I need to put this into a pricture frame for my living room (or my next résumé);-)

Best Regards,

Chris Büttner

TomThomson SSC Guru Points: 104773 More actions · Answer 5

Paul White (6/24/2013)
sharath.chalamgari (6/24/2013)
http://support.microsoft.com/kb/295305
The author should have included that reference in the explanation instead of guessing at how parsing works (and getting it wrong).

+ rather more than just 1

Tom

Revenant SSC-Forever Points: 42467 More actions · Answer 6

KWymore (6/24/2013)
Nice discussion even if the original explanation was a bit flawed. Thanks for the question Sergiy.

+1 with thanks

Michael Poppers SSCrazy Points: 2151 More actions · Answer 7

Mike Is Here (6/24/2013)
I really didn't care for this question, you must fix all errors regardless of the order they appear.
I selected the wrong answer with the User error, which was half right.

+1 😀

David Conn SSCertifiable Points: 6010 More actions · Answer 8

Overall this is a Good QOTD. The Lesson about Parsing happening before Execution certainly brought me back to doing the Basics in the correct order.

David

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

Nice question, thanks.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

Thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

sqlnaive SSCoach Points: 17437 More actions · Answer 11

sqlnaive

SSCoach

Points: 17437

July 2, 2013 at 5:54 am

#1629008

Good question. Thank you. 🙂