Tag: rowstore

Batch Mode Hacks for Rowstore Queries in SQL Server

By Kendra Little on May 11, 2017

Category: query-performance , sql-server

What’s batch mode?

Batch mode was introduced as a way to help SQL Server process data from columnstore indexes faster. The whole idea with columnstore is that you pull big compressed sets of rows out for aggregation or other operations in big chunks.

Batch mode is a way that operators can work on a “batch” of up to 900 values at a time, instead of working on individual rows. Batch mode can reduce the overhead of metadata and make more efficient use of your CPUs.

Index Types: Heaps, Primary Keys, Clustered and Nonclustered Indexes (Dear SQL DBA Episode 28)

on February 2, 2017

Category: indexing

Tags: architecture , clustered , columnstore , database-design , dear-sql-dba , heap , index , modeling , nonclustered , primary-key , rowstore

I see HEAP tables are found even when I know those tables have a clustered index, and I see a lot of forwarded records. This happens to 5 tables in my database. I can see the clustered and in some ones the non-clustered indexes… why are some scripts reporting them as heaps?