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,457 reads
This week Steve found a question of whether SQL Server 2019 uses more CPU than 2016.
2023-04-01
652 reads
2023-03-13
400 reads
2021-09-08
768 reads
In this article we look at the Hybrid Buffer Pool available in SQL Server 2019 and how to enable and disable this feature for SQL Server.
2021-08-09
2021-04-27
831 reads
2021-02-25
510 reads
2021-02-11
777 reads
I have explored the SQL Server 2019, Intelligent Query Processing Feature – “Table Variable Deferred Compilation”.
The script contains some theory at the top and links to read.
After that, there are required queries to run on SQL Server 2019.
This way we can see the feature in action and look at it's strengths and caveats.
2020-08-03
1,554 reads
2020-06-23
840 reads
By Steve Jones
This was an interesting thing I saw in a Question of the Day submission....
I thought I didn’t care about linting, and lately, I haven’t written a lot...
Want to blend your love of marketing with the power of data? Becoming a...
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
/* I'm trying to eliminate (write out) this function 'largest_date', but SQL Server 2016...
Hi everyone, I’ve been tasked with migrating a Standalone SQL Server instance to a...
What is returned when I run this code in SQL Server 2022?
CREATE TABLE CatIndex
( indexval VARCHAR(20)
)
GO
INSERT dbo.CatIndex (indexval) VALUES ('1'), ('2'), ('3')
GO
SELECT CHOOSE(indexval, cast('2025-01-01' AS DATE), CAST('2025-02-01' AS DATE), CAST('2025-03-01' AS DATE))
FROM dbo.CatIndex AS ci See possible answers