SQL Server Query Challenge
Industries & Applications

Winners of the 2016 SQL Server® Query Challenge Conquered All

They came.  They queried.  They conquered.

 

The results of the PASS #Summit16 – SQL Server Query Challenge are in!

We announced the Challenge as part of SanDisk’s prelude to PASS in this post:
The SQL Server® Query Challenge!

The SQL Server® Query Challenge was the brain child of SanDisk Data Propulsion Lab manager Niall MacLeod.  The setup featured a live workstation boasting shiny new Windows Server 2016 bits.  A Hyper-V instance hosted SQL Server 2016 RTM on which SQL geekwrights could practice their mad skills.  The Challenge transcended mere query tuning and focused instead on often overlooked yet vital aspects of performance:  instance, OS, and hardware configurations.  Let me be clear:  No T-SQL query tuning was permitted.  And like a production emergency, time was of the essence—all scripted changes had to complete within five short minutes.  (In fact, the second place team’s changes clocked in at 4:59.86—only 140ms under the wire!)  After optimizations, the query was executed & duration was captured to determine the winners.

Baseline execution time was 4:30—even on SanDisk flash.  As you can see from the accompanying table, the winners flipped the /faster bit by an order of magnitude or more.  In fact, the winning team enhanced perf by 35x—well over an order and closing in on two orders of magnitude faster!

Here are the results of the intrepid souls who took the SQL Server® Challenge and won big.  How big? Each winner was awarded a SanDisk Extreme PRO SSD!

Winning Time
(sec)
SanDisk
Extreme PRO SSD
CategoryWinners
7.1974x 960GBTeamMark Wilkinson
Tracy Boggiano
Brian Carrig
Kevin Feasel
29.9254x 480GBTeamBrent Unruh
Ben Geddes
Rich Baumet
Mark Elsen
30.2204x 240GBTeamJoe Chang
Ben Law
Elliot  Hutchins
Ron Thul
39.092960GBIndividualPhil Portnoy
77.587480GBIndividualRobert Hendrix

 

Customers & SanDisk staff alike—we all had a hoot.  Our friend Mike Weiner of the SQL Server Customer Advisory Team (SQL CAT) reports his customers entered a team who couldn’t keep themselves away, “Whatever you guys are doing at the SanDisk booth, they’re addicted!”

Worry not if you missed the Query Challenge this year.  By overwhelming demand we’ll bring it back next year for a well-deserved encore!

Takeaway: Optimal Performance Starts with a Robust Infrastructure

Optimal performance starts with a robust infrastructure, including SanDisk flash, yet engineering discipline demands implementation of best practices to fully leverage your hardware investment—and doing so can make a profound difference in the way we interact with our data.

Here’s the roster of our PASS-related posts:

SQL PASS Summit – 5 Ways to Bring Your Database to the Next Level
Speed and Balance: How to Win with SQL Server® 2016
SQL Server® 2016 Always On AGs – Over 70K Transactions/sec
The SQL Server® Query Challenge!

 

 

960GB SanDisk Extreme PRO SSD - SQL Server Challenge
The object of desire. The 960GB SanDisk Extreme PRO SSD. Learn more here and view the specs here. Achieve I/O bliss by putting three in your laptop.

 

Shepherded by SQL Server® Query Challenge creator & SanDisk Data Propulsion Lab Manager Niall MacLeod, contestants ruminate their next move
Shepherded by SQL Server Query Challenge creator & SanDisk Data Propulsion Lab Manager Niall MacLeod, contestants ruminate their next move.

 

 

Grand prize winners of the SQL Server® Query Challenge each holding a 960GB SanDisk Extreme PRO SSD
Grand prize winners of the SQL Server Query Challenge each holding a 960GB SanDisk Extreme PRO SSD.
Second place winners of the SQL Server Query Challenge
Second place winners of the SQL Server Query Challenge each holding a 480GB SanDisk Extreme PRO SSD.
Third place SQL Server Query Challenge team rep
Third place SQL Server Query Challenge team rep holding Four-of-a-Kind—a winning hand!

 

 

Leave a Response

Jimmy May
Jimmy May is a SQL Server Certified Master and is a SQL Server Technologist for SanDisk Data Propulsion Lab.Jimmy was a Principal Architect in Microsoft IT and formerly a Senior Program Manager for the SQL Server Customer Advisory Team (SQL CAT) where he managed the Customer Lab which hosts the biggest, fastest, and most interesting SQL Server apps from around the world. His last day job was Senior Database Architect for one of the world’s largest, SQL Server high-throughput OLTP DBs. He was a founder & on the executive committees of both the Indiana Windows User Group (www.iwug.net) & Indianapolis Professional Association for SQL Server (www.indypass.org).His passion is “flipping the /faster bit”; his motto is “change the world or go home”. Visit his SQL Server performance and personal productivity blog at http://sqlblog.com/blogs/jimmy_may.