2025-03-24
546 reads
SQL Server 2022
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.
2024-11-22
486 reads
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.
2023-12-06
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.
2023-12-01
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.
2023-10-30
3,700 reads
2023-05-12
503 reads
2023-05-05
158 reads
2023-04-28
325 reads
2023-04-21
313 reads
2023-04-14
337 reads
Blogs
Query multiple Azure SQL Databases
I was sick of changing context in Azure Data Studio while cleaning up things...
KDA: Echoes of Deception - Case 3
By Zikato
The crime spree in Digitown is not ending. This time 20 cars have been...
The Book of Redgate: Do Your Best Work
By Steve Jones
One of our mission statements in the Book of Redgate says: attempt to do...
Forums
Helpful Management Studio Settings and Features
Comments posted to this topic are about the item Helpful Management Studio Settings and...
The Minimal Linked Server
Comments posted to this topic are about the item The Minimal Linked Server
The AI View From Above
Comments posted to this topic are about the item The AI View From Above
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers