Introduction to Indexed Views in SQL Server

This article explains indexed views and provides an example that shows when they should be used to improve performance of a complex query.

"Surely this one will get a clustered index scan."

In which SQL Server stubbornly insists on doing key lookups way, way past the tipping point.

Stairway to ColumnStore Indexes Level 8: Optimizing Clustered Columnstore Indexes

In Level 7, we looked at optimizing rowgroup elimination for a nonclustered columnstore index. For a clustered columnstore index, the same technique can be used but the steps and syntax change a bit. This will be covered later – but first, let’s take a look at another significant difference between nonclustered and clustered columnstore indexes, […]

Tables Without Clustered Indexes

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index.

Where Clustered Index Keys Dare

We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes.
But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your nonclustered index.

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.

Best design for OLTP tables

NONclustered 2 clustered