Michael J. Swart

January 12, 2010

A puzzling situation…

Filed under: SQLServerPedia Syndication,Tongue In Cheek — Tags: — Michael J. Swart @ 12:01 am

A puzzling situation (my T-SQL Tuesday entry). This entry is an actual puzzle. Here I’m asking you to do the impossible (or at least the computationally difficult). Solve for ???:

Good luck

Good luck

Solution next week.

BTW, Don’t even try to attack this using a brute force approach. Even if you could test 1000 values a millisecond it would take like a whole decade to crack it.

Update 1/18/2010: See solution here

8 Comments »

  1. do you have text version of the tsql above? If not, I’ll type what i see.

    Comment by Rajib Bahar — January 12, 2010 @ 11:05 am

  2. Sure here you go:
    --visit: http:/www.michaeljswart.com/???.jpg
    DECLARE @big BIGINT = ???
    SELECT hashbytes('MD5', CONVERT(NVARCHAR ( 15 ) ,@big)) AS big_hashed
    /*
    big_hashed
    0x61B82A23F75874A88FCC096ED623D563
    */

    Comment by Michael J. Swart — January 12, 2010 @ 12:11 pm

  3. […] last week, I challenged the world to solve a puzzle. This was part of Adam Machanic’s T-SQL Tuesday. And while the entire world does not read my […]

    Pingback by An incentive, and a hint | Michael J. Swart — January 17, 2010 @ 8:26 pm

  4. Hi,

    I have forwarded your post to my friends and UG members. Let us see!

    Couple of people called and they said it is really difficult.

    Kind Regards,
    Pinal

    Comment by Pinal Dave — January 18, 2010 @ 5:36 am

  5. Thanks for spreading the word.

    Comment by Michael J. Swart — January 18, 2010 @ 3:33 pm

  6. This puzzle is the most frustrating (albeit intriguing) damn thing I’ve encountered in a while.

    But I’m determined. I’ll solve it even if it takes me an entire decade!

    –Brad

    Comment by Brad Schulz — January 18, 2010 @ 4:23 pm

  7. All right. All right.
    Congrats Brad. Winner.
    I’ll post a link to a solution within a day.

    Comment by Michael J. Swart — January 18, 2010 @ 4:28 pm

  8. […] Swart comes up with a difficult puzzle of his own. Can you reverse-engineer an MD5 hash? You shouldn't, in theory, be able to do so (at least, easily), but here are some hints… And if […]

    Pingback by Adam Machanic : T-SQL Tuesday #002: The Roundup — February 8, 2010 @ 2:15 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress