SQL Server 2019 builds on intelligent query processing features that were implemented in SQL Server 2017, and expands them to new areas of the database engine.

In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

With SQL Server 2019, batch mode over row store is available. I have done some limited testing with this in early releases and was pretty impressed with the results I had on aggregation queries.

Microsoft is readying SQL Server 2019 for release, with enhancements to help users combine structured and unstructured data, leverage data virtualization across a wider range of sources, and more.