Temporary Tables and Statistics in Stored Procedures

Question

Post reply

Temporary Tables and Statistics in Stored Procedures

lrasner

SSC Veteran

Points: 209
More actions
April 10, 2014 at 9:38 pm

#287525

Comments posted to this topic are about the item Temporary Tables and Statistics in Stored Procedures

Viewing 15 posts - 1 through 15 (of 20 total)

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 1

Interesting QotD - Learned something here.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

Stuart Davies SSCoach Points: 19505 More actions · Answer 2

Ford Fairlane (4/10/2014)
Interesting QotD - Learned something here.

+1

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Carlo Romagnano SSC-Insane Points: 22758 More actions · Answer 3

Ford Fairlane (4/10/2014)
Interesting QotD - Learned something here.

Good!

free_mascot One Orange Chip Points: 27164 More actions · Answer 4

Very interesting question!!

Thanks!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

Thanks lrasner, your question have just awakened me

Excellent QotD, Thanks for sharing

Raghavendra Mudugal SSChampion Points: 10658 More actions Follow · Answer 6

twin.devil (4/11/2014)
Thanks lrasner, your question have just awakened me
Excellent QotD, Thanks for sharing

+1

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Tony Bater SSCrazy Points: 2150 More actions · Answer 7

I am happy to say I got this right, but not so sure about the reason!

I didn't know the answer (so learned something here, and that's good), but worked it out from logic alone.

If #1 was true, then none of the others could be, and as the question states that there are two true statements, then #1 must be false.

If #2 was true, then so must #3 and #4, hence 3 true statements not 2. So #2 must be false.

Leaving #3 and #4 as the two true statements.

A good mental exercise, but not SQL:-)

Tony

SQLDoubleG Hall of Fame Points: 3100 More actions · Answer 8

Tony Bater (4/11/2014)
I am happy to say I got this right, but not so sure about the reason!
I didn't know the answer (so learned something here, and that's good), but worked it out from logic alone.
If #1 was true, then none of the others could be, and as the question states that there are two true statements, then #1 must be false.
If #2 was true, then so must #3 and #4, hence 3 true statements not 2. So #2 must be false.
Leaving #3 and #4 as the two true statements.
A good mental exercise, but not SQL:-)

+1

Nice question!

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 9

pmadhavapeddi22

SSCertifiable

Points: 5306

April 11, 2014 at 6:00 am

#1705216

Interesting QOD. Learned today

Mike Hays SSCommitted Points: 1871 More actions · Answer 10

Mike Hays

SSCommitted

Points: 1871

April 11, 2014 at 7:40 am

#1705287

Good Question, learned something new....

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 11

PChiragS

SSCarpal Tunnel

Points: 4965

April 11, 2014 at 7:57 am

#1705302

nice question.

thanks Lara for sharing.

sestell1 SSChampion Points: 10230 More actions · Answer 12

Nice question, thanks! Definitely something I'll be doing some more reading on.

SQLRNNR SSC Guru Points: 281344 More actions Follow · Answer 13

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

kapfundestanley SSCertifiable Points: 5637 More actions · Answer 14

Got it wrong ,but learned.

“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Temporary Tables and Statistics in Stored Procedures

Cookies on SQLServerCentral