SQL Server 2019: What’s New for Developers

SQL Server 2019 brings big data clusters, improved query processing, and better Linux support. Here are the highlights for developers.

Intelligent Query Processing

• Batch mode on rowstore: Faster analytical queries
• Memory grant feedback: Automatic memory adjustments
• Table variable deferred compilation: Better estimates

New T-SQL Features

-- APPROX_COUNT_DISTINCT for fast approximate counts
SELECT APPROX_COUNT_DISTINCT(CustomerId) FROM Orders;

-- UTF-8 support
CREATE TABLE Users (Name VARCHAR(100) COLLATE Latin1_General_100_CI_AS_SC_UTF8);

Accelerated Database Recovery

Near-instant recovery regardless of transaction log size. Game changer for large databases.

References

• What’s New in SQL Server 2019