I Gotta See the Code

Question

Post reply

I Gotta See the Code

Andy Warren

SSC Guru

Points: 119902
More actions
June 15, 2014 at 12:53 pm

#309150

Comments posted to this topic are about the item I Gotta See the Code
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
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]

mickyT SSChampion Points: 10360 More actions · Answer 1

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

Good question Andy

mister.magoo SSC-Forever Points: 47068 More actions · Answer 2

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.

MM

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

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 3

Interesting question, thanks

Hope this helps...

Ford Fairlane
Rock and Roll Detective

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

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

rhythmk SSCertifiable Points: 7271 More actions · Answer 5

Nicely framed QotD. Thanks Andy.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

Mighty SSCrazy Eights Points: 9063 More actions · Answer 6

Mighty

SSCrazy Eights

Points: 9063

June 16, 2014 at 5:36 am

#1721902

[Monday morning issue... remark was useless]

batgirl SSCarpal Tunnel Points: 4979 More actions · Answer 7

batgirl

SSCarpal Tunnel

Points: 4979

June 16, 2014 at 6:40 am

#1721928

Darn itchy trigger finger :angry:

Need.More.Coffee

ssimmons 2102 SSCommitted Points: 1634 More actions · Answer 8

ssimmons 2102

SSCommitted

Points: 1634

June 16, 2014 at 8:11 am

#1721964

2 out of 3, oh well.

TomThomson SSC Guru Points: 104773 More actions · Answer 9

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.

Tom

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 10

PChiragS

SSCarpal Tunnel

Points: 4965

June 16, 2014 at 9:08 am

#1721990

nice question Andy..

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 11

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.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

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

free_mascot One Orange Chip Points: 27169 More actions · Answer 13

Interesting question, thank you Andy.

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

Hany Helmy SSChampion Points: 13921 More actions · Answer 14

Koen Verbeeck (6/16/2014)
Again an outstanding question. Thanks!

+1

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant