We All Have It
You know those tables, right? The ones where developers went and got lazy or didn’t know any better and decided every string column was going to be gigantic.
They may have read, of course, that SQL …
Category: Indexing
Common SQL Server Consulting Advice: Adding Indexed Views
I am a heading
In the age of column store indexes, indexed views have a bit less attractiveness about them. Unless of course you’re on Standard Edition, which is useless when it comes to column store.
I think the biggest …
Common SQL Server Consulting Advice: Adding Computed Columns
Active Blooper
Remember yesterday? Yeah, me either. But I do have access to yesterday’s blog post, so I can at least remember that.
What a post that was.
We talked about filtered indexes, some of the need-to-know points, when to …
Common SQL Server Consulting Advice: Adding Filtered Indexes
Home Star
For all the good indexes do, sometimes you just don’t need them to cover all of the data in a table for various reasons.
There are a number of fundamentals that you need to understand about them (that …
Common SQL Server Consulting Advice: Adding Indexes To Replace Multiple Indexes
Buffet Tables
If you’ve ever spent any time reading about relational database theory, you’ve probably read all sorts of things about normal forms and all that good stuff. You’ve also probably immediately forgotten all of it.
At least that’s what …
Common SQL Server Consulting Advice: Adding And Removing Indexes
A Good Thing
Since you’re here reading this, I’m going to assume you know what food is. Further, I’m going to assume that you also know what salt is, because salt plays a pretty big part in how good or …
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
Software Vendor Mistakes With SQL Server: Indexing #Temp Tables Incorrectly
Understanding
I’ve covered this sort of information in previous posts, like:
But some points should be made together, so I’m going to combine them …
Software Vendor Mistakes With SQL Server: Thinking Index Rebuilds Solve Every Problem
Salt Flats
It’s hard to believe that this is still a lively debate, given how far technology has come since the original conversations around if and when fragmentation is a problem were a thing, but here we are in …