# Temporary Tables and Statistics in Stored Procedures

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

• Interesting QotD - Learned something here.

Hope this helps...

Ford Fairlane
Rock and Roll Detective

• 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

• Ford Fairlane (4/10/2014)

Interesting QotD - Learned something here.

Good!

• Very interesting question!!

Thanks!

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

• Thanks lrasner, your question have just awakened me 😀

Excellent QotD, Thanks for sharing

• 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.

• 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

• 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!

• Interesting QOD. Learned today

• Good Question, learned something new....

• nice question.

thanks Lara for sharing.

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

• 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

• Got it wrong ,but learned.

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

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