SQL Server 2016 SP2 CU2 Available

On July 16, 2018, Microsoft released SQL Server 2016 SP2 CU2, which is Build 13.0.5153.0. There are 21 fixes in the public fix list, including a number of fixes in the SQL performance, SQL Engine, and High Availability fix areas. Microsoft has also released SQL Server 2016 SP1 CU10, which is Build 13.0.4514.0. There are […]

T-SQL Tuesday #104: Code I Have Written That I Would Hate to Live Without

Bert Wagner (b/t) is hosting T-SQL Tuesday #104. The invitation is to write about code you’ve written that you would hate to live without. For me, this is almost a no-brainer! My DMV Diagnostic Queries represent a lot of code that I would hate to live without. I use them on a daily basis to […]

SQL Server Diagnostic Information Queries for July 2018

This month, there are improvements to seven of the the SQL Server 2012 and newer versions of the queries, with a new column that shows whether there is a missing index warning in the cached query plan. A reader named Håkan Winther made this useful suggestion. I have also developed a T-SQL script that you […]