I Gotta See the Code

  • Comments posted to this topic are about the item I Gotta See the Code

  • Must read question properly before answering. Missed the pick 3 😀 .... again. Time for coffee.

    Good question Andy

  • I got tripped up by the encryption bit, as I did not take the phrase "You also determine that encryption is not used in this database" to mean that the procedure could not be encrypted, rather that TDE was not being used <- I thought this was included to trick us into avoiding the possibility that the procedure could be encrypted. :crazy:

    Not complaining though, a bit more thought on my part would have left me choosing between 4 answers and from the wording this would have been the one to be excluded...so it's my own fault for being to quick to answer!

    Thanks for the question.


    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • Interesting question, thanks

    Hope this helps...

    Ford Fairlane
    Rock and Roll Detective

  • Again an outstanding question. Thanks!

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

  • Nicely framed QotD. Thanks Andy.

    To post your question use below link


  • [Monday morning issue... remark was useless]

  • Darn itchy trigger finger :angry:


  • 2 out of 3, oh well.

  • Good question.

    I managed to tick one wrong box (ALL) and omit one right one (just the proc).

    New resolution: I will answer QOTD only when fully awake.


  • nice question Andy..

  • Thank you for post, Andy, really good one. These types of questions... kind of remembers me taking up certification exam... 🙂

    ww; Raghu
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Thanks for the question Andy. Knew I would get it wrong, but didn't mind, as I knew I was going to learn something.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Interesting question, thank you Andy.

    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Koen Verbeeck (6/16/2014)

    Again an outstanding question. Thanks!


    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Viewing 15 posts - 1 through 15 (of 19 total)

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