The Global Hebrew Virtual Chapter is an online gathering place for SQL Server DBAs and Business Intelligence professionals to discuss all things SQL Server in Hebrew language.

Inspired by the PASS SUMMIT 2013, this virtual chapter is about finding a way for DBAs and BI professionals to network virtually in Hebrew language.

Next Meeting

Mon, Mar 10 2014 17:00 (GMT+02:00) Jerusalem


Big Data inside: clustered columnstore index in SQL Server 2014

RSVP: https://attendee.gotowebinar.com/register/2067531917322807810

Session recording: https://attendee.gotowebinar.com/recording/1280234312974836226

Big Data inside: clustered columnstore index in SQL Server 2014

One of the most interesting new features in SQL Server 2014 is updatable clustered columnstore index. Actually it is a major breakthrough that brings core SQL Server to the league of products like Vertica, Sybase IQ etc - those capable of analyzing hundreds of gigabytes of data in real-time. But like any powerful tool, it should be treated with caution. In this session we will start with brief overview of columnstore index in general and then dive into clustered columnstore index internals: how it works, how it is updated, how to use it efficiently and how to avoid huge performance issues when clustered columnstore index isn't used in a proper way. And as usual - demos, demos, demos.


SQL Server database consultant with vast experience in many aspects of database architecture, administration and complex performance troubleshooting. Specialties:Scalable database architecture, complex performance troubleshooting, programming for performance.