Foreign Key Fun

Question

Foreign Key Fun

TomThomson

SSC Guru

Points: 104773
More actions
March 5, 2015 at 9:20 pm

#295836

Comments posted to this topic are about the item Foreign Key Fun
Tom

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

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

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

Thanks, Tom - a great question, as I come to expect from you.

I till hope you will appear in Redmond, which would give me an opportunity to take you to the Bellevue whiskey bar, as I promised some time before...

patricklambin SSCrazy Eights Points: 9994 More actions · Answer 2

Thanks for this good question.

I found the good choices only because I have "spied" a debate during the last Paris SQL Server Staturdays 2014 about this kind of topic.

When I dared to ask why it is possible to create a temp table with a foreign key without an error , nobody knew the answer. The table has been created because it was existing and useable without no problem. No explanation.. Bad luck for me ( I am appreciating clear explanations because it is easier to remember the problem ) but I did not forget this problem.

Neil Burton SSC-Insane Points: 22999 More actions · Answer 3

Dammit! Didn't see select three!!!!!

On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
—Charles Babbage, Passages from the Life of a Philosopher

How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

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

Awesome question Tom, well done.

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

Toreador SSChampion Points: 11365 More actions · Answer 5

Wish I'd noticed who wrote the question before I answered! I'd have ignored the obvious and looked a bit closer for the 'trick' 😉

call.copse SSCoach Points: 18048 More actions · Answer 6

Interesting and informative, also wholly correct AFAICS 🙂 thanks.

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

Nice question, Tom. Good, clear and logical thought, just like I'd expect from you. I learned something new today, as I've never seen the skip before. Thanks.

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

RLilj33 SSCrazy Points: 2153 More actions · Answer 8

Thanks for the question. I wasn't aware of this restriction, so I learned something new today.

P.S. As a data professional, I prefer to use the term 'junque'. 😛

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 9

I found the question to be little confusing as it asked to know if temp tables were created. Could have been slightly different. However I hot the right options.

Thanks.

Eirikur Eiriksson SSC Guru Points: 182911 More actions · Answer 10

Eirikur Eiriksson

SSC Guru

Points: 182911

March 6, 2015 at 10:36 am

#1782235

Elementary my dear ~~Dr. Watson~~ Mr. Thomson

😎

Mark Cowne One Orange Chip Points: 26952 More actions · Answer 11

Great question, got it wrong but definitely learned something new.

____________________________________________________

Deja View - The strange feeling that somewhere, sometime you've optimised this query before

How to get the best help on a forum

http://www.sqlservercentral.com/articles/Best+Practices/61537

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 12

Thanks for the question. Learned something about temp tables.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 13

Ed Wagner (3/6/2015)
Nice question, Tom. Good, clear and logical thought, just like I'd expect from you. I learned something new today, as I've never seen the skip before. Thanks.

+1

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

stephen.long.1 SSCrazy Points: 2582 More actions · Answer 14

Fantastic question, Tom, and very interesting, as I expected when I saw that you wrote it. I learned something today (which is the whole reason for QotD).