T-SQL Tuesday Retrospective #010: Indexes
(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… Read More »T-SQL Tuesday Retrospective #010: Indexes
Home »
Indexes
Using indexed views? What is an imprecise or non-deterministic convert?
After last week’s post about using WITH (NOEXPAND) to query indexed views even on SQL Server Enterprise Edition, this week is a short but interesting… Read More »Using indexed views? What is an imprecise or non-deterministic convert?
Using indexed views? Don’t forget this important tip.
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… Read More »Using indexed views? Don’t forget this important tip.
Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up colourful lights. Here goes: If… Read More »Disable, don’t delete those indexes
Does rebuilding my clustered index also rebuild my non-clustered indexes?
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… Read More »Does rebuilding my clustered index also rebuild my non-clustered indexes?
On clustered indexes, clustering keys and primary keys
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… Read More »On clustered indexes, clustering keys and primary keys