Joe Sack

Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Click here for a full bio.

Exploring Low Priority Lock Wait Options in SQL Server 2014 CTP1

Posted by Joe Sack on September 18, 2013 1 Response »

Sep 182013

Joe Sack (@josephsack) looks into some new locking behavior, involving rebuilds and partition switching, available in SQL Server 2014.

Exploring Partition-Level Online Index Operations in SQL Server 2014 CTP1

Posted by Joe Sack on September 13, 2013 7 Responses »

Sep 132013

Joe Sack (@josephsack) takes a look at how online index operations have been improved to take advantage of parallelism in SQL Server 2014.

Exploring SQL Server 2014 SELECT INTO Parallelism

Posted by Joe Sack on August 23, 2013 7 Responses »

Aug 232013

Joe Sack (@josephsack) takes a first glimpse at the SQL Server 2014 enhancements to SELECT INTO: it can now perform in parallel with no code changes.

Observer Overhead and Wait Type Symptoms

Posted by Joe Sack on July 11, 2013 11 Responses »

Jul 112013

Joe Sack (@josephsack) of SQLskills.com shows us that we might not always be able to make an accurate correlation between wait statistics and observer overhead, depending on the method being used to observe a system.

Avoid HA/DR Solution Self-Delusion

Posted by Joe Sack on June 18, 2013 1 Response »

Jun 182013

SQLskills.com's Joe Sack (@josephsack) discusses some of the assumptions people can make when deciding on high availability / disaster recovery solutions they're going to use with SQL Server.

Troubleshooting SQL Server CPU Performance Issues

Posted by Joe Sack on May 28, 2013 4 Responses »

May 282013

Joe Sack (@josephsack) of SQLskills.com outlines his approach to troubleshooting CPU performance issues in SQL Server.

The Case of the Cardinality Estimate Red Herring

Posted by Joe Sack on April 19, 2013 5 Responses »

Apr 192013

SQLskills' Joe Sack (@josephsack) walks us through an interesting scenario where we might blame a query performance issue on parameter sniffing or bad statistics, when it actually turns out that a check constraint is the best solution to keep the optimizer honest.

1 2