SQL Server Quickie #12 – Nested Loop Operator
Today I have uploaded the 12th SQL Server Quickie to YouTube. This time I’m talking about the Nested Loop Join Operator in SQL Server. Thanks for watching! -Klaus
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
Performance improvements in SQL Server 2014
SQL Server 2014 will be an amazing release regarding all the various performance enhancements that are part of this new release. Over the last months I have already done a huge amount of work and tests on the latest CTP version of SQL Server 2014, and I have already blogged about my experience. In this …
Buffer Pool Extensions in SQL Server 2014
In todays blog posting I want to talk about Buffer Pool Extensions that are introduced with SQL Server 2014. As you know, the Buffer Pool is one of the main memory consumers in SQL Server. When you read data from your storage, the data is cached in the Buffer Pool. SQL Server caches Execution Plans …
SQL Server Quickie #11 – Non Clustered Indexes
Today I have uploaded the 11th SQL Server Quickie to YouTube. This time I’m talking about Non Clustered Indexes in SQL Server. Thanks for watching! -Klaus
