(You can see previous T-SQL Tuesday retrospectives by visiting this link.) In September 2010, Michael J. Swart (blog | Twitter) invited us to talk about indexes. Indexes are strange things. You never need to explicitly…
Today after fighting with designing a view that let me create a clustered index on it (indexed views — also known as materialized views — are awesome in the right context!), I kept running into the same…
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered index would cause non-clustered indexes to be rebuilt as well, because the non-clustered index includes…
Many smart people have spoken about clustering keys and primary keys before, so here’s a less smart take on the topic. Let’s define some things first: Clustered Index – the column (or columns) by which…