Tag: query performance

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

1 Apr 2020 · 6 min read

SQL Server 2019 Cumulative Update 4: Fixes and Enhancements for Better Performance

SQL Server 2019 Cumulative Update 4 addresses critical bugs including memory leaks and incorrect query results. Here is what changed and why it matters for production environments.

Read article →
6 Feb 2020 · 6 min read

SQL Server 2017 Cumulative Update 19: The Latest Fixes and Improvements

SQL Server 2017 Cumulative Update 19 addresses critical bugs including VSS backup freezes and slow query performance. Here is what KB4535007 fixes and why it matters in production.

Read article →
15 May 2018 · 6 min read

How to Fix Performance Dashboards for SQL 2008

Learn how to apply Microsoft's compatibility update to get the SQL Server 2005 Performance Dashboard working correctly against SQL Server 2008 and 2008 R2 instances.

Read article →
15 May 2018 · 4 min read

How to Tune Maximum Degree of Parallelism (MAXDOP)

Getting MAXDOP wrong is one of the most common causes of SQL Server performance problems. Learn how to choose the right setting for your workload.

Read article →
21 Oct 2017 · 6 min read

Gettin’ Techie SET STATISTICS TIME

SET STATISTICS TIME reveals exactly how long SQL Server spends parsing, compiling and executing your queries. Learn to read the output and diagnose slow query performance with confidence.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.