T-SQL

External Article

Ordered Columnstore Indexes in SQL Server 2022

  • Article

One of the more challenging technical details of columnstore indexes that regularly gets attention is the need for data to be ordered to allow for segment elimination. In a non-clustered columnstore index, data order is automatically applied based on the order of the underlying rowstore data. In a clustered columnstore index, though, data order is not enforced by any SQL Server process. This leaves managing data order to us, which may or may not be an easy task.

2023-08-09

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Maricaya Hub:Cs.08216977726

By meyhomecapital

Whatsapp:08216977726 Jl. Veteran Selatan No.86, Maricaya Sel., Kec. Mamajang, Kota Makassar, Sulawesi Selatan 90142

BCA KCP Kopo Telp/wa 085169998803

By jewellerypk

Telp/wa 085169998803 Jl. Raya Kopo No.26 A-B, Panjunan, Kec. Astanaanyar, Kota Bandung, Jawa Barat...

BCA KCU ASIA TELP/CS:083135765355

By njspain

Whatsapp:083135765355 Jl. Asia, Simpang, Jl. Bakaran Batu No.1 C, Sei Rengas II, Kec. Medan...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers