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?
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.
Last week, I wrote about what should have been a fast system but was performing very poorly, weighing heavily on tempdb I/O performance. Our original… Read More »The ongoing saga of a slow tempdb on a fast server