SQLBlog.org

archives disclaimers
archives shortcuts bad habits
disclaimers
SQLBlog Home
bad habits
shortcuts
MERGE NOLOCK dates dynamic SQL
splitting SQL Server 2022 how to ask

On-Demand Hotfix for Parallel Batch-Mode Deadlocks in SQL Server 2014

Aaron Bertrand SQL Server / SQL Server 2014

Today Microsoft released a critical, on-demand hotfix for customers using Columnstore indexes in SQL Server 2014. The hotfix addresses a scenario where a batch-mode scan that has gone parallel can deadlock, and the deadlock cannot be resolved automatically.

The hotfix can be downloaded from KB #3048751 and will bump SQL Server to 12.0.2488.

For more broad advice about hotfixes and cumulative updates for SQL Server 2014, see this blog post.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)