Synonyms and Temp Tables

Question

Synonyms and Temp Tables

Steve Jones - SSC Editor

SSC Guru

Points: 736210
More actions
December 27, 2014 at 11:42 am

#74506

Comments posted to this topic are about the item Synonyms and Temp Tables

Viewing 14 posts - 1 through 13 (of 13 total)

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

Ed Wagner SSC Guru Points: 287026 More actions · Answer 1

Steve Jones - SSC Editor (12/27/2014)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/120079/">Synonyms and Temp Tables</A>

I don't use global temp tables very much myself, but it's good to know. Thanks and have a safe and Happy New Year.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

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

Umer Akram

SSC-Insane

Points: 22209

December 29, 2014 at 7:20 am

#1766763

Nice question. Thanks for sharing

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 3

RK Mandava

SSCarpal Tunnel

Points: 4153

December 29, 2014 at 7:36 am

#1766772

Nice Question, learned something new..

david.gugg SSCertifiable Points: 6096 More actions · Answer 4

Wow, I didn't understand synonyms to be so abstract. Thanks for the question!

Be still, and know that I am God - Psalm 46:10

TomThomson SSC Guru Points: 104773 More actions · Answer 5

david.gugg (12/29/2014)
Wow, I didn't understand synonyms to be so abstract. Thanks for the question!

Watch out for the question about synonyms of non-global temorary tables. 😀

Tom

manik_anu SSCrazy Points: 2377 More actions · Answer 6

Very very very easiest question....:-P

Manik
You cannot get to the top by sitting on your bottom.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

akljfhnlaflkj

SSC Guru

Points: 76202

December 30, 2014 at 3:09 pm

#1767096

Thanks for the question.

Andre Ranieri SSCrazy Points: 2819 More actions · Answer 8

Thanks for the question. I learned something new today.

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 9

Ed Wagner (12/29/2014)
Steve Jones - SSC Editor (12/27/2014)
Comments posted to this topic are about the item <A HREF="/questions/T-SQL/120079/">Synonyms and Temp Tables</A>
I don't use global temp tables very much myself, but it's good to know. Thanks and have a safe and Happy New Year.

Like Tom said above, watch out for the question on synonyms on non-global temp tables. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Toreador SSChampion Points: 11365 More actions · Answer 10

manik123 (12/30/2014)
Very very very easiest question....:-P

Not that easy - I assumed that there must be a catch so went for the non-obvious answer and got it wrong :hehe:

Andy Warren SSC Guru Points: 119902 More actions · Answer 11

I didnt know, had to guess - wrongly!

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

Ken SSCoach Points: 17191 More actions · Answer 12

I tested this out just now and I found it interesting that if you drop the global temp table, the synonym still exists in sys.synonyms. I had to issue a drop statement to drop the synonym as well. According to BOL, this is intended for flexibility.

I'd be curious to see how people are actually using synonyms.

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

Thanks for the question.

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