SQL Server 2014

Extreme Transaction Processing (XTP, Hekaton) – the solution to everything?

My complete last week was dedicated to XTP (Extreme Transaction Processing), better known as Hekaton, that is introduced with SQL Server 2014. My main goal of the week was to get a better understanding of Hekaton, the current limitations, and the scalability of this amazing new In-Memory technology. This blog posting covers the following things …

Extreme Transaction Processing (XTP, Hekaton) – the solution to everything? + read more

Improved Temp Table Caching in SQL Server 2014

Under some preconditions SQL Server is able to cache Temp Tables. Caching Temp Tables means that SQL Server doesn’t have to recreate them, when you are creating the same Temp Table over and over again. This can improve the throughout of your workload tremendous, because SQL Server doesn’t has to access specialized pages in memory …

Improved Temp Table Caching in SQL Server 2014 + read more

Non-Clustered Indexes on Table Variables in SQL Server 2014

Earlier today I have seen a Tweet from Paul White, where he tweeted that SQL Server 2014 supports Non-Unique Clustered and Non-Clustered Indexes for Table Variables in SQL Server 2014. So I had to start up my virtual machine and try it out, because this would be a awesome new feature. Table Variables are great, …

Non-Clustered Indexes on Table Variables in SQL Server 2014 + read more

First steps with Extreme Transaction Processing – Hekaton

A few hours ago Microsoft released the first public CTP of SQL Server 2014. The download and the installation went very smooth, the only new restriction is that you are not allowed to install the CTP 1 version in parallel with any other SQL Server version. Aaron Bertrand has blogged about that new behavior. In …

First steps with Extreme Transaction Processing – Hekaton + read more

My 2 cents on SQL Server 2014

Yesterday during the opening keynote of TechEd North America Microsoft released the first official details about the next version of SQL Server: SQL Server 2014. There are huge improvements in the area of High Availability, Performance, and Scalability, on which I want to concentrate in this weblog posting. Disclamer: This blog posting is based on …

My 2 cents on SQL Server 2014 + read more