SQLpassion BLOG

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