Yesterday Pluralsight published my new course, “SQL Server 2012: Nonclustered Columnstore Indexes”. The intent behind this course was to provide a fast ramp-up on the
In this blog post we’ll explore columnstore index batch execution mode limits. I’m using SQL Server 2012 Developer Edition, version 11.0.3349 (SP1, CU3). To start
Chalk this post up as an “exploratory” mission based on the following question… How do I track which LOB pages are associated with a specific
My last post about nonclustered Columnstore indexes was written back on February 25th, 2012 (Exploring Columnstore Index Metadata, Segment Distribution and Elimination Behaviors). Amazed by
I was interested in exploring various questions about columnstore indexing this morning – and I realized I should probably blog about what I observed. This
This post covers examples from Denali SQL Server 2012 CTP3, version 11.0.1440. In my last post I hinted towards some interesting findings regarding parallelism and
This post covers examples from Denali CTP3, version 11.0.1440. I was working with Denali’s columnstore index feature this last week and was testing it on
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.