Parameter Sensitive Plan Optimization vs. Parameter Sniffing: What SQL Server Fixes and What It Doesn't

See how SQL Server's Parameter Sensitive Plan optimization handles skewed parameters, how to verify dispatcher plans, and where PSP still falls short.

Five SQL Server 2022 T-SQL Functions You Should Be Using Right Now

SQL Server 2022 brought powerful new T-SQL functions that eliminate long-standing workarounds. This article walks through five of the most impactful additions — GENERATE_SERIES, GREATEST/LEAST, DATE_BUCKET, the WINDOW clause, and IS NOT DISTINCT FROM — with practical code examples you can use immediately.

Database Ledger in SQL Server 2022

Learn how ledger databases and ledger tables work in SQL Server 2022.

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