TSQL Challenge 63 – Update

Categories: News, Professional, Scripts, SSC
Comments: No Comments
Published on: November 14, 2011

If you recall, I like Sudoku.  I even posted a script for solving it via TSQL.  I went so far as to enter my script into a TSQL Challenge.  That all started way back in August.  Today, I have an update!!

I was notified this morning from BeyondRelational.com that I have earned a new badge.  Cool, what’s the badge?  I clicked the link and it took me to this badge.
Huh?  I’m a winner of the SQL Sudoku Challenge?  Awesome!

Looking it over, I am winner #3.  This means I could have done better with my solution.   And looking at the other solution stats, it appears I will need to find time to see what the others did to make their solutions go sooooo fast.  I have some learning to do – woohoo.

So, now that means I need to post my solution.

[codesyntax lang="tsql"]

[/codesyntax]

 

Sadly, that is not the most recent version of the script that I had.  I had intended on submitting this version, which is still slightly faster.

[codesyntax lang="tsql"]

[/codesyntax]

Still, I am certain that (without having looked at the other winning solutions) this is not on par with the best solutions.  And I have a lot to learn.

No Comments - Leave a comment

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">






Calendar
November 2011
M T W T F S S
« Oct   Dec »
 123456
78910111213
14151617181920
21222324252627
282930  
Content
SQLHelp

SQLHelp

  • @awanderingmind: Anyone have an idea why I'm not seeing any LoginTimers records in sys.dm_os_ring_buffers? Only Error and ConnectionClosed. #sqlhelp
  • @pshore73: #SQLHelp In @olahallengren Index script, can I use a query to pass results to the database parameter? Need to skip a DB for Index Maint.
  • @DoktorKermit: @sqlstudent144 I think there's a few legacy systems out there, so I would do it, but not i great details #sqlhelp
  • @SQLTaiob: Could not cleanup worktable IAM chains to allow shrink or remove file operation. Checked tempdb usage and nothing longrunning. #sqlhelp
  • @sqlstudent144: Do enough people still use DTS that it's worth blogging on a DTS bug? #sqlhelp
  • @DoktorKermit: .@clausmunch Have you tried restarting, and if that it's not helping - try reinstalling #Trolling #IknowClaus #sqlhelp
  • @clausmunch: Anyone has some insights into worktables in Tempdb? It seems as we have an issue where they don't dissapear in TempDB #sqlhelp #sqlfamily
  • @mellie81: Indeed @sql_handle @SqlrUs no time, that's why I wondered. Maybe there's a big nogo on a detach?Just hope it's a timesaver for me. #sqlhelp
  • @AskSQL: Permissions on folder look same but somehow SQL cannot write to folder. Anyway to sort of resync permission on folder for SQL? #SQLHELP 2/2
  • @AskSQL: Data drive had issues so I stopped SQL & moved folder somewhere then new drive added (same drive letter). SQL is not starting #SQLHELP 1/2

Welcome , today is Thursday, October 2, 2014