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

This month's discount Comprehensive Database Performance Health Check Testimonials

Glazed tiles sorted into tall single-color stacks in a workshop, a hand lifting the whole blue stack from the row.

Columnstore Indexes for Reporting Tables

May 13, 2012

SQL Performance

ColumnStore Index, Data Warehousing, SQL Index, SQL Performance, SQL Server

Columnstore indexes for reporting tables can cut scan work, but clustered and nonclustered designs affect loading and point lookups differently.

A maypole with five ribbons stretched out to stakes around it like a star

Star Schema Queries and How SQL Server Runs Them

January 16, 2011

SQL Performance

ColumnStore Index, Data Warehousing, Execution Plan, SQL Joins, SQL Server

Star schema queries join a large fact table to focused dimensions; learn bitmap filters, columnstore, and indexes that support the real workload.