Dropping Temp Tables

Question

Post reply

Dropping Temp Tables

Steve Jones - SSC Editor

SSC Guru

Points: 737519
More actions
December 19, 2018 at 9:06 pm

#77358

Comments posted to this topic are about the item Dropping Temp Tables

Viewing 10 posts - 1 through 9 (of 9 total)

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

HappyGeek SSCoach Points: 18729 More actions · Answer 1

Thought I knew the answer to this so learned something new, thanks Steve.

...

allinadazework SSCarpal Tunnel Points: 4506 More actions · Answer 2

Cracking good question that! Found some really good stuff here by Paul White explaining temp object caching if anyone is interested...
https://sqlkiwi.blogspot.com/2012/08/temporary-object-caching-explained.html
Cheers, and Happy Christmas all!

Nakul Vachhrajani SSChampion Points: 10294 More actions · Answer 3

Learnt something new today. Thank-you!

Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com

Follow me on
Twitter: @sqltwins

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

Umer Akram

SSC-Insane

Points: 22209

December 20, 2018 at 5:58 am

#2016934

Great question, Thanks for sharing.

MilesC Ten Centuries Points: 1078 More actions · Answer 5

Very good question!! I didn't get it right, but learned something.

chris geswein Old Hand Points: 375 More actions · Answer 6

Interesting! I have to admit, I didn't know the answer, but used the process of elimination and then chose the most shocking of the 2 answers left. Now I'm going to have to read up on why it works that way.