Optimizing OLTP Analytics with SQL Server Clustered Columnstore Indexes
Learn how to implement Clustered Columnstore Indexes in SQL Server to enable HTAP workloads, reduce I/O, and accelerate analytical queries on live transactional data.
Loading…
ReadMeFeed / Community knowledge
#sql-server
Real questions. Useful conversations. Find the people who know your stack.
microsoftsqlserverImplementing Row-Level Security in SQL Server for Tenant Data Isolation
Learn how to move from manual data filtering to Row-Level Security (RLS) to enforce per-user data isolation transparently without rewriting application logic.
Using Query Store to Pin a Good Plan and Stop Performance Regressions in SQL Server
Learn how to enable Query Store, identify a regressed query, force a known‑good plan, and verify the fix while understanding the overhead trade‑off.
Implementing Table Partitioning in SQL Server for Large Datasets
Learn how to implement table partitioning in SQL Server using partition functions and schemes to improve maintenance and performance for massive datasets.
Implement Optimistic Concurrency with SQL Server rowversion in EF Core
Prevent silent lost updates in EF Core by adding a SQL Server rowversion concurrency token. This guide covers entity configuration, migration, conflict handling for connected and disconnected scenarios, and verification steps.
entityframeworkcoreWhen Columnstore Indexes Actually Pay Off in SQL Server
Columnstore indexes can turn minute-long scans into sub-second queries — but only for the right workload. A concrete 5M-row test shows how to verify the gain and where the feature backfires.
Using SQL Server Query Store to Catch and Fix Query Regressions After an Upgrade
Learn how to enable Query Store, capture a performance baseline, spot regressed statements after a deployment, and temporarily force a good plan while you work on a permanent fix.
Architecture Note: Using SQL Server Always Encrypted with Secure Enclaves for In‑Place Computations
Learn how to protect a single column with SQL Server Always Encrypted and secure enclaves while still enabling in‑place equality joins, including requirements, design, trust boundaries, checks, failures, and when to revisit the design.
Using System‑Versioned Temporal Tables in SQL Server to Build an Auditable Data Layer
Implement SQL Server’s system‑versioned temporal tables to automatically track every change to a row. Learn how to create, query, and monitor temporal tables, and understand the trade‑offs like storage overhead and write‑latency.