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 Category Winners
7.197 4x 960GB Team Mark Wilkinson Tracy Boggiano Brian Carrig Kevin Feasel
29.925 4x 480GB Team Brent Unruh Ben Geddes Rich Baumet Mark Elsen
30.220 4x 240GB Team Joe Chang Ben Law Elliot  Hutchins Ron Thul
39.092 960GB Individual Phil Portnoy
77.587 480GB Individual Robert 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!

 

 

Jimmy is a SQL Server Certified Master and is a SQL Server Technologist with a passion for “flipping the /faster bit”.