November 12, 2015 at 4:55 am
Steve Jones - SSC Editor (11/11/2015)
I saw the Comcast one. It's getting crazy.I'm about to start giving legitimate companies incorrect information, just so I know if my stuff is released, and perhaps it has limited value.
Oh I started lying about things like birth date and other stuff a long time ago. Facebook thinks I'm nearly 100 years old.
November 12, 2015 at 5:07 am
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907
That's quite good:-D I might be tempted to offer to take a nap for someone:hehe:
😎
November 12, 2015 at 5:25 am
Eirikur Eiriksson (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907That's quite good:-D I might be tempted to offer to take a nap for someone:hehe:
😎
Now there's a good idea. 😀
November 12, 2015 at 5:40 am
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907
I saw this same request on a different sight where they posted a screen shot of the test. It looked to have space for the answer in it.:-)
November 12, 2015 at 5:42 am
Brandie Tarvin (11/12/2015)
Oh I started lying about things like birth date and other stuff a long time ago. Facebook thinks I'm nearly 100 years old.
I see a lot of customers who register email addresses that are unique for this site. I assume that's so if they get junk mail or suchlike to that account they know where the source is. An interesting idea but does mean keeping a track of a lot of email addresses.
November 12, 2015 at 5:49 am
BrainDonor (11/12/2015)
Brandie Tarvin (11/12/2015)
Oh I started lying about things like birth date and other stuff a long time ago. Facebook thinks I'm nearly 100 years old.I see a lot of customers who register email addresses that are unique for this site. I assume that's so if they get junk mail or suchlike to that account they know where the source is. An interesting idea but does mean keeping a track of a lot of email addresses.
Actually, that might be a result of a mask program that sends all the emails to the same location but use different combo of characters so they know if their email addys got sold or stolen.
November 12, 2015 at 6:14 am
BrainDonor (11/12/2015)
I see a lot of customers who register email addresses that are unique for this site.
You can also do things like
myname+sitename@<domain> (or maybe the other way around). GMail supports it, most other mail provides should. The + on the address shouldn't change where it's delivered, just allow you to categorise things.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 12, 2015 at 6:24 am
GilaMonster (11/12/2015)
BrainDonor (11/12/2015)
I see a lot of customers who register email addresses that are unique for this site.You can also do things like
myname+sitename@<domain> (or maybe the other way around). GMail supports it, most other mail provides should. The + on the address shouldn't change where it's delivered, just allow you to categorise things.
I didn't know that - I'll have to have a play.
November 12, 2015 at 6:29 am
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907
I just glanced at the pop-up summary and the title, and my first thought was "homework."
It's almost tempting to take some time one evening for one of these (I think) fairly obvious homework questions, to come up with the most complicated, hard to read, redundant, confusing, redundant, obfuscated queries possible, that still returns the expected results.
But my time is worth more than trolling someone like that...
November 12, 2015 at 6:32 am
jasona.work (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907I just glanced at the pop-up summary and the title, and my first thought was "homework."
It's almost tempting to take some time one evening for one of these (I think) fairly obvious homework questions, to come up with the most complicated, hard to read, redundant, confusing, redundant, obfuscated queries possible, that still returns the expected results.
But my time is worth more than trolling someone like that...
Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't format the code. It'll be impossible to read.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 12, 2015 at 6:34 am
Grant Fritchey (11/12/2015)
jasona.work (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907I just glanced at the pop-up summary and the title, and my first thought was "homework."
It's almost tempting to take some time one evening for one of these (I think) fairly obvious homework questions, to come up with the most complicated, hard to read, redundant, confusing, redundant, obfuscated queries possible, that still returns the expected results.
But my time is worth more than trolling someone like that...
Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't format the code. It'll be impossible to read.
Make sure to put it all on one long line...
😀
It would almost be worth it, *if* I could be a fly on the wall when the instructor asks them to explain their query...
:hehe:
November 12, 2015 at 6:39 am
jasona.work (11/12/2015)
Grant Fritchey (11/12/2015)
jasona.work (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907I just glanced at the pop-up summary and the title, and my first thought was "homework."
It's almost tempting to take some time one evening for one of these (I think) fairly obvious homework questions, to come up with the most complicated, hard to read, redundant, confusing, redundant, obfuscated queries possible, that still returns the expected results.
But my time is worth more than trolling someone like that...
Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't format the code. It'll be impossible to read.
Make sure to put it all on one long line...
😀
It would almost be worth it, *if* I could be a fly on the wall when the instructor asks them to explain their query...
:hehe:
Yeah, that would be the reward from all the hard work to complicate things beyond belief. Be sure to base it on views on views on views. 😉
November 12, 2015 at 6:40 am
BrainDonor (11/12/2015)
GilaMonster (11/12/2015)
BrainDonor (11/12/2015)
I see a lot of customers who register email addresses that are unique for this site.You can also do things like
myname+sitename@<domain> (or maybe the other way around). GMail supports it, most other mail provides should. The + on the address shouldn't change where it's delivered, just allow you to categorise things.
I didn't know that - I'll have to have a play.
I didn't either. I'm going to have to look into that. Thanks.
November 12, 2015 at 6:46 am
jasona.work (11/12/2015)
Grant Fritchey (11/12/2015)
jasona.work (11/12/2015)
BrainDonor (11/12/2015)
My Grandmother had an expression, when she thought somebody was being really lazy - "Sit down and I'll walk around for you" - http://www.sqlservercentral.com/Forums/Topic1735905-392-1.aspx#bm1735907I just glanced at the pop-up summary and the title, and my first thought was "homework."
It's almost tempting to take some time one evening for one of these (I think) fairly obvious homework questions, to come up with the most complicated, hard to read, redundant, confusing, redundant, obfuscated queries possible, that still returns the expected results.
But my time is worth more than trolling someone like that...
Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't format the code. It'll be impossible to read.
Make sure to put it all on one long line...
😀
It would almost be worth it, *if* I could be a fly on the wall when the instructor asks them to explain their query...
:hehe:
Coming soon!
The official, unofficial, not approved, not not unofficial SQL Server Central query obfuscation contest! Write the simplest query in the most complicated way possible! Prizes include, but are not guaranteed to be:
9. One of Steves' Hawaiian shirts!
4. Signed picture of Grant Fritchey with muttonchops and a soup-strainer mustache!
3.14. Gail Shaw at your birthday party in a Deadpool costume!
:hehe:
(Gotta love how I volunteer others for this!)
All prizes subject to availabilty and willingness of the participants, offer not valid within the Sol system or its' Oort cloud.
November 12, 2015 at 6:54 am
Grant Fritchey (11/12/2015)
Still, could be fun. Build out a nested CTE inside a function, use the same table aliases over and over, don't format the code. It'll be impossible to read.
Sounds like any program I have written and come back to after six months. 😀
Viewing 15 posts - 51,331 through 51,345 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply