Half Baked
In my quest to love indexed views more, I’m always trying new things with them to solve problems.
Occasionally, I am pleasantly surprised by what can be accomplished with them. Occasionally.
Today was not an occasion. Let’s take …
Category: Indexed Views
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 …
Software Vendor Mistakes With SQL Server: Not Using Filtered Indexes Or Indexed Views
Basic Training
In yesterday’s post, we covered some of the basics of designing nonslustered indexes to make queries go faster, but sometimes those aren’t quite enough.
In today’s post, I’m going to give you more of my paid training about …
Software Vendor Mistakes With SQL Server: Not Cleaning Up Old Indexes
Annals
The longer your application has been around, the more developers and queries it has seen. There are a lot of ways the indexes could look, depending on how you approach performance issues with customers.
If you’re the type of …
Starting SQL: SQL Server Indexes Store Key Column Data In Order
Index Skit (0:39)
The most common types of indexes you’re going to see in your life are of the rowstore variety.
As much as I love columnstore, it’s probably not something you’re going to see a whole lot outside of …
Be Careful When You Alter SQL Server Indexed Views
Yo, Is That Mary?
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 …