ColumnStore Index Archives - Page 4 of 4 - SQL Authority with Pinal Dave

SQL SERVER – Inserting into ColumnSet with SPARSE Columns

November 21, 2015

There are a number of blogs around using SPARSE columns here. Here are few of them for reference and can be used as a great learning experience. SQL SERVER – 2008 – Introduction to SPARSE Columns SQL SERVER – 2008 – Introduction to SPARSE Columns – Part 2 SQL SERVER…

SQL SERVER – Basics ColumnStore FAQ – Part II

November 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Index

I wrote the first part of FAQ in here. This is not a typical blog post but more of a process oriented topic when working with ColumnStore Indexes. With the advancements done in SQL Server 2016, I know that this is going to be even more critical to understand some…

SQL SERVER – COLUMNSTORE and COLUMNSTORE_ARCHIVE data compression

February 23, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Index

In earlier blogs on “Fundamentals of Columnstore Index”, I took a simple approach on taking a tour of how to create a simple Columnstore index. Having said that, SQL Server 2014 supports columnstore and columnstore archival compression for columnstore tables and indexes. Columnstore tables and indexes are always stored with…

SQL SERVER – Finding Size of a Columnstore Index Using DMVs

June 10, 2012

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

ColumnStore Index, SQL Index

Columnstore Index is one of my favorite enhancement in SQL Server 2012. A columnstore index stores each column in a separate set of disk pages, rather than storing multiple rows per page as data traditionally has been stored. In case of the row store indexes multiple pages will contain multiple rows of…

SQL SERVER – Columnstore Index and sys.dm_db_index_usage_stats

May 14, 2012

Pinal Dave

SQL Performance

ColumnStore Index, SQL DMV, SQL Index, SQL Scripts, SQL Server

As you know I have been writing on Columnstore Index for quite a while. Recently my friend Vinod Kumar wrote about SQL Server 2012: ColumnStore Characteristics. A fantastic read on the subject if you have yet not caught up on that subject. After the blog post I called him and asked what should I write next on this subject. He suggested that I should write on DMV script which I have prepared related to Columnstore when I was writing our SQL Server Questions and Answers book. When we were writing this book SQL Server 2012 CTP versions were available. I had written few scripts related to SQL Server columnstore Index. I like Vinod’s idea and I decided to write about DMV, which we did not cover in the book as SQL Server 2012 was not released yet. We did not want to talk about the product which was not yet released.