Microsoft SQL Server guides, questions and discussions

Article0 replies3,241 followingPosted 19 Apr 2026, 21:49 UTC13.9K views1,258 votes

Choosing the Right Indexing Strategy for SQL Server Workloads

A decision guide for SQL Server indexing strategies, comparing clustered, non-clustered, covering, and columnstore indexes to balance read performance and write overhead.

Community & Careers · Guide

Community & Careers

Article0 replies3,241 followingPosted 19 Apr 2026, 21:49 UTC13.9K views1,258 votes

Choosing the Right Indexing Strategy for SQL Server Workloads

A decision guide for SQL Server indexing strategies, comparing clustered, non-clustered, covering, and columnstore indexes to balance read performance and write overhead.

Community & Careers · Guide

microsoftsqlserver database-indexing performance-tuning

Community & Careers

Article0 replies3,960 followingPosted 06 Sept 2026, 17:24 UTC69K views657 votes

Using Query Store in SQL Server to Detect Plan Regressions

Query Store lets you capture every query’s plan and runtime stats in SQL Server, giving a durable baseline for performance tuning and regression detection. Enable it once, tune retention, and use plan_compare to spot regressions in production.

Community & Careers · Blog

microsoftsqlserver performance-tuning sql-server