BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//SQLBits/com
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-MS-OLK-FORCEINSPECTOROPEN:TRUE
BEGIN:VEVENT
DTSTART:20140719T071500Z
DTEND:20140719T081500Z
LOCATION:SQLBits Conference - Coalport 1
SUMMARY:Column Store Index and Batch Mode Scalability Deep Dive
DESCRIPTION:This session will take a deep dive into query scalability with column store indexes and batch mode, this presentation will illustrate how by leveraging vectorised processing and CPU L2/3 cache batch mode scales and compare this to row mode. Stack walking will be used to quantify the cost of conventional page and row compression, column store versus the new to SQL 2014 column store archive compression and row mode versus batch mode operators. The affect of storage that can and cannot keep up with the available CPU resource will be covered along with how well batch mode scales across 24 schedulers.
X-ALT-DESC;FMTTYPE=text/html:

Column Store Index and Batch Mode Scalability Deep Dive

This session will take a deep dive into query scalability with column store indexes and batch mode, this presentation will illustrate how by leveraging vectorised processing and CPU L2/3 cache batch mode scales and compare this to row mode. Stack walking will be used to quantify the cost of conventional page and row compression, column store versus the new to SQL 2014 column store archive compression and row mode versus batch mode operators. The affect of storage that can and cannot keep up with the available CPU resource will be covered along with how well batch mode scales across 24 schedulers.

Chris Adkin

Chris is a freelance SQL DBA / developer who has been using SQL Server since 2000, his passion is for scaling SQL Server and understanding how the engine behaves at depth when pushed to its limits.