Kruti's SQL Blog

Blogs

Azure SQL Managed Instance: Boost Performance with Read-Scale Out

By

The Business Critical tier of Azure SQL Managed Instance offers the read-scale out feature...

Free Cloud Environment Setup: A Beginner’s Guide

By

Cloud computing is essential for modern development, data storage, and scalable applications. Setting up...

Copying an Azure SQL database between two Azure SQL Instances in two different subscriptions.

By

I recently had to copy an Azure SQL database (SQL db) from one subscription...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

SQL Server Columnstore Index Fragmentation

By Grant Fritchey

Comments posted to this topic are about the item SQL Server Columnstore Index Fragmentation

do i lose "what this object depends on" etc when moving sprocs to etl server

By stan

Hi i was surprised to see the approach my coworkers used to sunset talend...

Visit the forum

Question of the Day

SQL Server Columnstore Index Fragmentation

The columnstore index is absolutely different than the traditional rowstore b-tree index. Because of this, it doesn't suffer from the same kind of fragmentation across pages as the b-tree index. Yet, it does suffer from a type of fragmentation brought about by an excess of deleted rows in a rowgroup and a lack of compression of storage because more things are in the delta store. While b-tree indexes use dm_db_index_physical_stats to show fragmentation, which system tables or DMVs can be used in SQL Server (prior to SQL Server 2025) to determine columnstore fragmentation?

See possible answers