Unintended Side Effects – Sleeping Sessions Holding Locks Jonathan Kehayias shows why you should always take the time to investigate why a blocking session isn't releasing locks quickly. Jonathan Kehayias ◆ July 3, 2019 1
Some ANY Aggregate Transformations are Broken Paul White explores two cases where the introduction of the internal ANY aggregate by the optimizer may cause wrong results. Paul White ◆ July 1, 2019 8
Common SQL Server Mishaps Tim Radney talks about some of the typical SQL Server mishaps he comes across out in the wild, and resources you can use to avoid them in your own environments. Tim Radney ◆ June 21, 2019 0
T-SQL bugs, pitfalls, and best practices – joins Itzik Ben-Gan continues his series on T-SQL bugs, pitfalls, and best practices, with some interesting examples of joins gone wrong. Itzik Ben-Gan ◆ June 14, 2019 9
Troubleshooting Variable Memory Grants in SQL Server Erin Stellato shares her approach to using Query Store to help troubleshoot performance issues involving memory grants. Erin Stellato ◆ June 5, 2019 1
Minimal Logging with INSERT…SELECT and Fast Load Context Paul White explains minimal logging for inserts into b-tree indexes using Fast Load Context, and why it might not always work as expected. Paul White ◆ May 29, 2019 0
Examining the Performance Impact of an Adhoc Workload Erin Stellato discusses the performance impact of a predominately adhoc workload in SQL Server. Erin Stellato ◆ May 22, 2019 3
Minimal Logging with INSERT…SELECT into Empty Clustered Tables Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table. Paul White ◆ May 16, 2019 0
T-SQL bugs, pitfalls, and best practices – subqueries Itzik Ben-Gan resumes his blog series on T-SQL bugs, pitfalls, and best practices, treating an issue with correlated column references in subqueries. Itzik Ben-Gan ◆ May 8, 2019 0
Introduction to Wait Statistics Paul Randal provides a detailed introduction to troubleshooting SQL Server workload performance using wait statistics. Paul Randal ◆ May 7, 2019 0
Minimal Logging with INSERT…SELECT into Heap Tables Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into a table without a clustered index. Paul White ◆ May 1, 2019 5