The End of SQL Server 2019

Steve has a few thoughts after the end of mainstream support for SQL Server 2019.

Batch Execution Mode on a Rowstore in SQL Server 2022

Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.

Has SQL Server Performance Improved?

This week Steve found a question of whether SQL Server 2019 uses more CPU than 2016.

The Managed Instance Link

Migrate databases from SQL Server to SQL Managed Instance

Understanding Hybrid Buffer Pool in SQL Server 2019

In this article we look at the Hybrid Buffer Pool available in SQL Server 2019 and how to enable and disable this feature for SQL Server.

Types of indexes available in SQL Server 2019

SQL Server 2019 PMEM

Tempdb Improvements in 2019

Table Variable Deferred Compilation (SQL 2019)

I have explored the SQL Server 2019, Intelligent Query Processing Feature – “Table Variable Deferred Compilation”.

The script contains some theory at the top and links to read.
After that, there are required queries to run on SQL Server 2019.
This way we can see the feature in action and look at it's strengths and caveats.