Monthly Archive: January 2019

Make SQL Server DMV Queries Backward Compatible

Make SQL Server DMV Queries Backward Compatible

This tip shows a neat trick with CROSS APPLY that lets older versions of SQL Server ignore columns in your metadata queries that don't exist yet.

Four ways to improve scalar function performance in SQL Server

Four ways to improve scalar function performance in SQL Server

If you use scalar user-defined functions, and can't take advantage of new handling in SQL Server 2019, see some other ways to reduce the impact on performance.