SQLServer

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

08/04/2014 / By / Hekaton, SQL Server 2014, SQLServer / 8 Comments

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

08/04/2014 / By / SQL Server 2014, SQLServer / 1 Comment

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

SQLpassion Performance Tuning Training Plan – Signup

Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan – you get a weekly email packed with all the essential knowledge you need to know about performance tuning on SQL Server.