Using table variables in T-SQL

The Table Backup

New SQL Server 2022 Functions

There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.

Cardinality Estimation Feedback in SQL Server 2022

Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model.

Accelerated Database Recovery enhancements in SQL Server 2022

We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.

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.

SQL Server 2022 VLF Changes

SQL Server 2022 Log File IFI

DOP Feedback and QDS

Percentile Memory Grant Feedback