SQL Server 2014

Statistics with Ascending Key Column Values

In today’s blog posting I want to talk about a very common problem within SQL Server: handling statistics with ascending key columns. As you already know, every statistics object in SQL Server has an associated Histogram. The histogram describes the data distribution for a specific column with multiple steps. SQL Server supports up to 200 …

Statistics with Ascending Key Column Values + read more

The Illusion of Updateable Clustered ColumnStore Indexes

In todays blog posting I want to concentrate in more details on the Updateable Clustered ColumnStore Index that is introduced with SQL Server 2014. Before we go down to the details, I want to give you a brief overview about their first appearance in SQL Server 2012, and their limitations. ColumnStore Indexes in SQL Server …

The Illusion of Updateable Clustered ColumnStore Indexes + read more

How to throttle your Storage with Resource Governor in SQL Server 2014

In todays blog posting I want to talk about a very cool enhancement in SQL Server 2014: you are now finally able to throttle queries regarding their needed IOPS! Resource Governor was introduced back in SQL Server 2008, but the feature set was somehow limited: you were just able to limit CPU times (which is …

How to throttle your Storage with Resource Governor in SQL Server 2014 + read more