Wayne Sheffield

About Wayne Sheffield

I’ve been involved with technology for 36 years. Since 1998, I’ve been working with SQL Server, since version 6.5. I am a Microsoft Certified Master and Microsoft Certified Solutions Master (and all those prerequisites). Earning my MCM has definitely been a career highlight for me. Even with that under my belt, I welcome any opportunity to learn new things about SQL. I love tuning queries for optimal performance, and automating tasks. I co-authored SQL Server 2012 T-SQL Recipes: A Problem-Solution Approach, frequently participate and present at SQL Server events (including SQLSaturday’s), and I write for SQLServerCentral.com. The most rewarding project I have been a part of, to date, is my marriage. Career-wise, it would be the journey to earning my MCM.

Automating DBCC PAGE, part 2 – determining object names on pages

In my last post, I demonstrated how using DBCC PAGE can be automated by using the “WITH TABLERESULTS” option. In this post, we will continue with another look at how this can be done.

On a nice wintry day, your city ended up being covered in several feet of snow. During the course of the night, […]

By |February 3rd, 2015|SQL Group|0 Comments

Automating DBCC Page

Way back in 2006, Paul Randal documented DBCC PAGE on his Microsoft blog at http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/10/625659.aspx. In his post, you will notice that in order to return the output from DBCC PAGE to the screen, you need to enable trace flag 3604 first. The above blog post shows a few examples of the results and utilizing […]

By |December 23rd, 2014|SQL Group|0 Comments

Persisting DBCC output data

Most of the DBCC commands return their results as textual output, even if you have SSMS configured to return result sets to a grid. This makes examining the output a manual process that is prone to errors. It sure would be nice if there was a way to return the output to a grid.

If we […]

By |November 26th, 2014|SQL Group|0 Comments

Dodging Phantoms

October… the month of Halloween. Spooky events. SQL Server has all kinds of Halloween-ish themed activities like Split Brains, Zombies, Ghosts, Phantoms, and of course Halloween itself. In this post, we’re going to mill about with Phantoms a bit.

Phantoms in SQL Server are actually called “Phantom Reads”. This ectoplasmic phenomenon manifests itself when an identical […]

By |October 29th, 2014|SQL Group|0 Comments

How TCP Chimney Offloading Affects SQL Server

TCP Chimney Offload transfers network traffic workload processing from the CPU to a network adapter that supports TCP Chimney Offload. This feature was introduced with Windows Server 2003 SP2, and it was called the Microsoft Scalable Networking Pack (SNP). Since Windows Server 2008, these features are a base part of these operating systems, so they […]

By |September 16th, 2014|SQL Group|1 Comment

How to improve SQL Server’s IO performance by up to 40%

In my last article, I started off talking about checking various settings that make a performance difference prior to jumping into query tuning. This article continues the investigation into performance affecting settings, by jumping straight into the storage subsystem. How would you like to make a single change to your drives and have the IO […]

By |August 12th, 2014|SQL Group|0 Comments

SQL Server’s hidden “Go Fast” button

When investigating a performance issue, the desired end result is already known… you need to make the queries run faster. It’s been my experience that most performance problems involve optimizing the query that is being run—sometimes the query needs a re-write to be more efficient, sometimes the tables being queried need a new (or modified) […]

By |July 15th, 2014|SQL Group|0 Comments