Foreign Key Fun

  • TomThomson

    SSC Guru

    Points: 104773

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

    Tom

  • Revenant

    SSC-Forever

    Points: 42467

    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: 9964

    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: 22187

    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: 258965

    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: 11253

    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: 17157

    Interesting and informative, also wholly correct AFAICS πŸ™‚ thanks.

  • Ed Wagner

    SSC Guru

    Points: 286980

    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.

  • RLilj33

    SSCrazy

    Points: 2153

    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: 33448

    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: 182430

    Elementary my dear Dr. Watson Mr. Thomson

    😎

  • Mark Cowne

    One Orange Chip

    Points: 26748

    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

    Thanks for the question. Learned something about temp tables.

  • SQLRNNR

    SSC Guru

    Points: 281243

    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: 2577

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

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

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