What You Should Know About SQL Server 2016 ColumnStore Indexes

One of the exciting features for data warehouse queries in SQL Server 2012 was the columnstore index. These are designed to provide good performance on analytical queries without the need to explicitly specify indexes. There were, however, many restrictions for their use, including: Columnstore indexes had fewer supported datatypes. Columnstore indexes were Non-updatable–once created, the table would become read-only. […]

Read More

2 Lesser Known Facts About Working with SQL Server Columnstore Indexes

Before we dig into the lesser known but important facts, I want to provide little background about the SQL Server Columnstore index. This feature was introduced in SQL Server 2012, but remains largely unknown. As the name suggests, a data page will store values only for the given column to which that page is allocated. Generally, […]

Read More

Partition Tables—Ways to Improve SQL Server Performance

Learn more about why and how to use partitioned tables in SQL Server to improve performance.

Read More