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
324 reads
SQL Server 2022
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,135 reads
2023-05-12
501 reads
2023-05-05
155 reads
2023-04-28
323 reads
2023-04-21
313 reads
2023-04-14
337 reads
2023-04-07
341 reads
Blogs
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
SQL Saturday Oregon & SW Washington 2024
By DataOnWheels
Wow I am so late in posting these notes! But this conference was amazing,...
Challenges Enterprises Face When Adopting AI
The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.
Forums
Transfer data from azure vm to blob storage
Hi Experts I want to move data/ some million rows from a Azure vm...
How do I fix the, "Unable to process the existing user settings" error message?
I'm sure I've asked this question in either this forum, or another one, in...
Cannot restore new DB
I have made an empty DB called "HJEM_BB" I try to fill it from...
Question of the Day
The AG Secondary Logs
What happens when an AG secondary receives a log record from the primary?
See possible answers