Clustered Columnstore Index

Creating Clustered Columnstore Indexes everywhere

by

In this post I discuss creating Clustered Columnstore Indexes everywhere. In other words, which clustered columnstore indexes you can create depending on your SQL Server version. Because in a previous post I mentioned I could create clustered columnstore indexes in SQL Server 2019 regardless of the database compatibility level. To clarify, it appears you can … Read more

A unique review of SQL Server index types

by

Introduction I want to do a unique review of SQL Server index types in this post. In order to help raise awareness about some of them. Because one thing I have noticed in various places is that people still tend to use the traditional clustered and non clustered indexes. However, I rarely see the filtered … Read more