Columnstore Indexes are Finally Sorted in SQL Server 2022
There’s a widespread misconception that SQL Server’s columnstore indexes are like an index on every column.
2022-07-22
ColumnStore Index
2022-06-20
499 reads
2022-06-06
400 reads
2022-05-23
418 reads
2021-02-11
317 reads
2020-02-25
728 reads
What are Columnstore Indexes?
Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to work with columnstore indexes, a different way to store tables that can drastically improve the performance of specific workloads.
2019-08-06
Update Statistics on a Columnstore index failed
SQL Server relies upon good, up-to-date statistics when creating query execution plans. Out-of-date statistics can cause queries to run slowly, or suddenly start consuming far more resources than is...
2019-04-17
2018-12-27
616 reads
2018-05-03
779 reads
Blogs
New Job -> Week 2 -> Creating a Checklist
This is part of a series of new job blog posts. You can find...
SQL Server 2022 Administration Inside Out
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
WIT/DEI Mental Health and Wellness Day Challenge to Present
Back in December 2019, I started presenting my session on mental health with lots...
Forums
Managed Instance Link and SQL Server 2022
Comments posted to this topic are about the item Managed Instance Link and SQL...
Passing parameters to query without TVFs
Comments posted to this topic are about the item Passing parameters to query without...
Capturing Data Changes
Comments posted to this topic are about the item Capturing Data Changes
Ask SSC