The Land Of Do-Overs
Of the new things in SQL Server 2019 that I plan on presenting about, the Batch Mode on Row Store (BMOR, from here) enhancements are probably the most interesting from a query tuning point of view.…
Category: Batch Mode
Batch Mode On Row Store Is Fickle
Thanks Though
I’m excited about this feature. I’m not being negative, here. I just want you, dear reader, to have reasonable expectations about it.
This isn’t a post about it making a query slower, but I do have some demos …
Different Ways To Get The Highest Value Part 3
Silent and Grey
In yesterday’s post, we looked at plans with a good index. The row number queries were unfortunate, but the MAX and TOP 1 queries did really well.
Today, I wanna see what the future holds. I’m …
SQL Server 2019: If You Want Adaptive Joins, You Need Wider Indexes
What You Make Of It
We’ve got this query. Handsome devil of a query.
You can pretend it’s in a stored procedure, and that the date filter is a parameter if you want.
SELECT u.DisplayName, p.Score FROM dbo.Users AS u…
Operator Time Oddities
SILENCE YOUR CELL PHONES
…Bad Guesses and Bad Choices: Does 2019 Batch Mode Help?
Bad Fit
In the last post, I tried to play some tricks on the optimizer to have Batch Mode make a query faster.
It didn’t quite work out the way I wanted.
That isn’t to knock Batch Mode. It’s …
Bad Guesses and Bad Choices: Does Tricky Batch Mode Help?
Notes and Notability
In the last post, I showed you a query where a bad plan was chosen because of bad guesses.
In this post, I’m going to see if Batch Mode will help anything.
To do that, we’re …