SQLPerformance.com “Troubleshooting SQL Server CPU Performance Issues”

My fifth guest blog post was published today on SQLPerformance.com: Troubleshooting SQL Server CPU Performance Issues In this post I describe the general framework you can use to perform root cause analysis for high CPU or CPU-related performance issues.

New Course: “SQL Server 2012: Nonclustered Columnstore Indexes”

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 aspects of this feature that you should consider when looking at whether or not this is a viable option for your SQL Server relational data warehouse workloads.  The course covers […]

Exploring Columnstore Index Batch Sizes

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 off with, I’ll create a table that uses six different supported nonclustered columnstore index data types: I’ll populate this table with 1,048,576 rows, all using the same value for each […]