Handcuffed
When you’re looking for queries to tune, it’s important to understand which part is causing the slowdown.
That’s why Actual Execution plans are so valuable in newer versions of SQL Server and SSMS. Getting to see operator timing and …
Category: columnstore
How Useful Is Column Store In 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 …
Batch Mode On Row Store vs Batch Mode Tricks
Quiet Time
I think Batch Mode is quite spiffy for the right kind of query, but up until SQL Server 2019, we had to play some tricks to get it:
- Do a funny join to an empty table with a
Making The Most Of Temp Tables Part 4: Batch Mode
Le Big Zoom Zoom
When you have queries that need to process a lot of data, and probably do some aggregations over that lot-of-data, batch mode is usually the thing you want.
Originally introduced to accompany column store indexes, it …
Columnstore Loading on Eight Socket Servers
I had a brief opportunity to do SQL Server workload testing on an eight socket server. It didn’t go well.
Sockets
I’ll give an extremely brief introduction to NUMA and sockets because I have a bit more free time these …
The Trillion Row Operator
SQL Server friend and excellent webmaster Mr. Erik C. Darling showed me a query plan gone wrong:
48 billion rows for a single operator is certainly a large number for most workloads. I ended up completely missing the point and …
SQL Server 2019 Disappointment: sp_estimate_data_compression_savings
Missed It The First Time
This is documented, but I know a lot of people are allergic to documentation, whether it’s writing or reading.
In SQL Server 2019:
- Exciting stuff: In memory tempdb!
- Exciting stuff: sp_estimate_data_compression_savings can evaluate columnstore
Paging Dr Column Store
And Cough
…
No Column Store Indexes With In-Memory Tempdb? No Problem!
Old Habits
Let’s say you’re on SQL Server 2019. No, seriously. It’s been out for a couple weeks now.
You could be.
I say that you could be because you’re the kind of brave person who tries new things and …