Four Non Mods
This post isn’t about modifying data. I don’t believe in doing that; get your data right the first time and you’ll avoid a lot of issues. You’ll also never need to worry about Merge.
I kid, of …
Tag: Query Plan
Understand Your Plan: Processing Data With A Join Operator
Your Girlfriend
Anyone who tells you there are only three types of joins in SQL Server isn’t your friend.
Okay, maybe that’s harsh. Maybe they’re just getting you prepared for the bonne promenade through all the many different faces a …
Understand Your Plan: Processing Data With An Aggregate Operator
Smack Dab
Aggregates can be useful for all sorts of things in a query plan, and can show up in many different forms.
It would be tough to cover all of them in a single post, but what I’d like …
Understand Your Plan: Getting Data With A Scan Operator
They Live
I’m not sure why scans got such a bad rap. Perhaps it’s a leftover from the Bad Old Days© when people worried about logical fragmentation and page splits.
What I mean to say is: scans are often treated …
Understand Your Plan: Getting Data With A Seek Operator
Rumble, Young Man, Rumble
People. People complain. People complain about SQL Server. That’s probably why I get paid to deal with it, but whatever.
One complaint I get to hear week in and week out is that SQL Server isn’t …
Understand Your Plan: Reading Operator Times In SQL Server Execution Plans
Wiseacre
When I was sitting down to figure out what to write about this, one of the topics that I thought would be interesting was the width of lines/arrows in query plans.
I sat here for half a day pecking …
No, Really: Don’t Optimize For Ad Hoc Workloads As A Best Practice
Better Late
A few weeks back, my friend Randolph (B|T) and I collaborated a bit on a blog post about Optimize For Ad Hoc Workloads.
Now that I’m a Microsoft Approved Blogger™️ and you all …
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
MAXDOP: The T-Shirt
Buttery Biscuits
In yesterday’s post, I showed you the promo video and abstract for my SQLBits precon.
In today’s post, I’m gonna offer you a little bribery to show up.
First, all attendees will get one of these lovely T-Shirts. …