SQL Server Quickie #7 – TempDb Latch Contention
Today I have uploaded the 7th SQL Server Quickie to YouTube. This time I’m talking about Latch Contention in TempDb. Thanks for watching! -Klaus
SQL Server Quickie #6 – THREADPOOL Starvation
Today I have uploaded the 6th SQL Server Quickie to YouTube. This time I’m talking about THREADPOOL Starvation in SQL Server. Thanks for watching! -Klaus
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 …
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
