Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.
Columnstore Bulk Load: Why Batch Size Decides Where Rows Land
Review columnstore bulk load batch sizes, inspect delta and compressed rowgroups, and measure the cost of forcing small groups to compress.
Index Size Estimate: Sizing an Index Before You Create It
Before you build an index, estimate its size and say what you assumed. Then check the guess against real pages on a copy.
Columnstore Rowgroup Health: Finding Small and Open Rowgroups
Inspect columnstore rowgroup health, understand small and deleted groups, and choose reorganize or rebuild from measured evidence.
Blind Index: Searching an Encrypted Column Without Decrypting
Encrypted emails cannot be searched, so store a keyed digest beside them. A hands-on demo of how it works, what it leaks and how rotation hurts.
How to List All the Nonclustered Indexes of Your Table? – Interview Question of the Week #155
How do you list all the clustered and nonclustered indexes of your table, including columnstore? Here is the script I use in my performance health checks.
How to List All ColumnStore Indexes with Table Name in SQL Server? – Interview Question of the Week #153
Question: How to List All ColumnStore Indexes with Table Name in SQL Server? As ColumnStore Indexes are getting more and more popular.