| 1 | What are delta stores and rowgroups in the context of columnstore indexes, and how do they affect performance over time? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Advanced |
| 2 | What kinds of workloads benefit the most from columnstore indexes, and which workloads should avoid them? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 3 | What is a columnstore index in SQL Server, and how is it different from a regular index? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Beginner |
| 4 | What is the difference between a clustered columnstore index and a nonclustered columnstore index? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Beginner |
| 5 | How would you decide whether to use a clustered columnstore index or a traditional partitioned rowstore table for a very large historical sales table? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Advanced |
| 6 | How does columnstore compression work, and why does it typically achieve much higher compression ratios than regular row based storage? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 7 | What tools or queries can you use to monitor the health and effectiveness of a columnstore index over time? SQL Server › Columnstore Indexes | SQL Server | Columnstore Indexes | Intermediate |
| 8 | How do filtered indexes work, and what specific scenarios benefit most from using one? SQL Server › Indexes | SQL Server | Indexes | Advanced |
| 9 | What is a covering index, and how does it help avoid an expensive lookup operation? SQL Server › Indexes | SQL Server | Indexes | Intermediate |
| 10 | What is In-Memory OLTP in SQL Server, and what performance benefit does it provide? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Beginner |
| 11 | What is table partitioning in SQL Server, and what problem does it help solve for very large tables? SQL Server › Partitioning | SQL Server | Partitioning | Beginner |
| 12 | What SQL Server edition requirements exist for using In-Memory OLTP features? SQL Server › In-Memory OLTP (Memory-Optimized Tables) | SQL Server | In-Memory OLTP (Memory-Optimized Tables) | Intermediate |
| 13 | How does partition elimination improve query performance for a partitioned table? SQL Server › Partitioning | SQL Server | Partitioning | Intermediate |
| 14 | What is a schema bound view, and what specific benefit does the WITH SCHEMABINDING option provide? SQL Server › Views | SQL Server | Views | Intermediate |
| 15 | What is an indexed view, and how can it improve the performance of complex, frequently run queries? SQL Server › Views | SQL Server | Views | Intermediate |