SQL Server 2019: What’s New for Developers

On this page

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

SQL5 lines
-- 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


Discover more from C4: Container, Code, Cloud & Context

Subscribe to get the latest posts sent to your email.

Written by

Nithin Mohan TK

Hello Namaste! 👋🏻 I'm an accomplished Enterprise Solution Architect & Engineering Leader with 20+ years of progressive experience architecting, building, and scaling transformative enterprise solutions. ⚜️ Solution Architect / AI & Cloud 📌 Galway, Ireland

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.