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
378 reads
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
378 reads
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
We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.
2023-12-01
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,279 reads
2023-05-12
501 reads
2023-05-05
156 reads
2023-04-28
324 reads
2023-04-21
313 reads
2023-04-14
337 reads
2023-04-07
341 reads
By Steve Jones
I started a short thread on Twitter/X and Bluesky recently after leaving the Tesla...
By Steve Jones
Life gets better as you replace transactions with relationships. – from Excellent Advice for...
I’ve been putting together a new PostgreSQL session called “Performance Monitoring for the Absolute...
Comments posted to this topic are about the item Limits, Not Goals
MS SQL Server/SSMS are my tools. As my project evolves I find I need...
SSL Certificate Chain Not Trusted Error in SQL Server Connection in Power BI I’m...
What is the precision, length, and scale for an int variable?
See possible answers