Groove Is In The Heart
When Brent posted about the availability of, and disappointment with creating ordered column store indexes in SQL Server 2022, I got to work.
I can’t have my dear friend Brent being all distraught with …
Category: Batch Mode
Considerations For Paging Queries In SQL Server With Batch Mode (Don’t Use OFFSET/FETCH)
First Things First
The first SQL Server blog posts that I ever read while trying to solve a specific problem here these two:
They sort of changed my …
Getting The Top Value Per Group With Multiple Conditions In SQL Server: Row Number vs. Cross Apply With MAX
Throat Music
In yesterday’s post, we compared a simple situation trying to find the post scoring post for each user.
In today’s post, we’re going to add another condition: we want the highest scoring post for each type of post …
Getting The Top Value Per Group In SQL Server: Row Number vs. Cross Apply Performance
Introductions
There are many ways to express queries in SQL. How different rewrites perform will largely be a function of:
- You not doing anything ridiculous
- Queries having good indexes in place
- The optimizer not seeing through your tricks and giving
Using Batch Mode for the “Matching Supply With Demand” Challenge
Itzik Ben-Gan posted an interesting T-SQL challenge on SQL performance dot com. I’m writing up my solution in my own blog post because I have a lot to say and getting code formatting right can be tricky in blog post …
Signs You Need Batch Mode To Make Your SQL Server Queries Faster
My Name Is
I speak with a lot of DBAs and developers who have either heard nothing about column store and batch mode, or they’ve only heard the bare minimum and aren’t sure where it can help them.
Here’s a …
How Useful Is Column Store Indexing In SQL Server Standard Edition?
Speed Limit
When I’m blogging about performance tuning, most of it is from the perspective of Enterprise Edition. That’s where you need to be if you’re serious about getting SQL Server to go as fast as possible. Between the unrealistic …
Multiple Distinct Aggregates: Still Harm Performance Without Batch Mode In SQL Server
Growler
Well over 500 years ago, Paul White wrote an article about distinct aggregates. Considering how often I see it while working with clients, and that Microsoft created column store indexes and batch mode rather than allow for hash …
Database Context Is Everything In SQL Server
Full Frontal
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you click from here. I’m also available …
Residual Predicates In SQL Server Query Plans
We Will Talk About Things And Have Fun Now
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount on to my blog readers if you …