SQLServer

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

Lock Escalations

In todays blog posting I want to talk about Lock Escalations in SQL Server. Lock Escalations are an optimization technique used by SQL Server to control the amount of locks that are held within the Lock Manager of SQL Server. Let’s start in the first step with the description of the so-called Lock Hierarchy in …

Lock Escalations + read more