The SQL Server Crossword

  • Kenneth.Fisher

    SSCoach

    Points: 19577

    Comments posted to this topic are about the item The SQL Server Crossword

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • jordonpilling

    SSCommitted

    Points: 1690

    Made the mistake of giving this to my team this morning, productivity is zero lol - best effort so far is 12 words, 9 to go!

    Knock Knock, Who's There?, sp underscore, sp underscore who?
    spid1, spid2, spid3....

  • anthony.green

    SSC Guru

    Points: 112212

    Got 15, only 6 more to go.



    How to post data/code for the best help - Jeff Moden[/url]
    Need a string splitter, try this - Jeff Moden[/url]
    How to post performance problems - Gail Shaw[/url]
    Managing Transaction Logs - Gail Shaw[/url]
    Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger[/url]

  • jordonpilling

    SSCommitted

    Points: 1690

    We just need 14 & 16 across now, but stuck to the max

    Bring on the Answers Kenneth Fisher :p

    Knock Knock, Who's There?, sp underscore, sp underscore who?
    spid1, spid2, spid3....

  • anthony.green

    SSC Guru

    Points: 112212

    jordonpilling - Thursday, November 16, 2017 7:22 AM

    We just need 14 & 16 across now, but stuck to the max

    Bring on the Answers Kenneth Fisher :p

    14 across I belive the answer is on this page https://docs.microsoft.com/en-us/sql/relational-databases/logs/control-transaction-durability

    I need 16 across myself also.



    How to post data/code for the best help - Jeff Moden[/url]
    Need a string splitter, try this - Jeff Moden[/url]
    How to post performance problems - Gail Shaw[/url]
    Managing Transaction Logs - Gail Shaw[/url]
    Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger[/url]

  • jordonpilling

    SSCommitted

    Points: 1690

    Can honestly, say, 10 years of looking after 30+ SQL servers, countless server builds, 1000's of hours maintaining, restoring and general DBa duties, not once have i come across DELAYED_DURABILITY - learnt something new! (although i would not touch it with a barge pole 🙂

    So yup, got everything now apart from 16 across.

    Looking forward to the answer!

    Knock Knock, Who's There?, sp underscore, sp underscore who?
    spid1, spid2, spid3....

  • anthony.green

    SSC Guru

    Points: 112212

    New 16 across was in relation to 4 part naming just for some reason the answer didn't seem right to me.

    https://technet.microsoft.com/en-us/library/ms187879(v=sql.105).aspx



    How to post data/code for the best help - Jeff Moden[/url]
    Need a string splitter, try this - Jeff Moden[/url]
    How to post performance problems - Gail Shaw[/url]
    Managing Transaction Logs - Gail Shaw[/url]
    Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger[/url]

  • Kenneth.Fisher

    SSCoach

    Points: 19577

    Yep. You got it. 16 across is just 4 part naming 🙂  

    I'm glad y'all are enjoying it.  I should have the answers posted to this discussion later tonight.

    Oh, and DELAYED DURABILITY isn't all that bad when you think about it.  It's fairly new so I'm not surprised you haven't seen it before.

    I wrote up my opinion on the risks here: https://sqlstudies.com/2016/04/12/the-risks-of-delayed-durability/

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

  • Kenneth.Fisher

    SSCoach

    Points: 19577

    Here is the answer key!

    Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

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

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