SQLServer
How SQL Server 2014 improves Online Operations that aren’t Online Operations
In todays blog posting I want to talk a little bit about Online Index Rebuild operations, and how they are improved in SQL Server 2014. As you know, SQL Server 2005 first introduced Online Index Rebuild operations. But these online operations are not really online operations, because SQL Server has to acquire a Shared Table …
How SQL Server 2014 improves Online Operations that aren’t Online Operations + read more
SQL Server Quickie #8 – Hash Indexes
Today I have uploaded the 8th SQL Server Quickie to YouTube. This time I’m talking about Hash Indexes in SQL Server 2014. Thanks for watching! -Klaus
Myths and Misconceptions about Hekaton
Over the last weeks and months, I invested a lot of my time to get a better understanding of Hekaton – the new In-Memory technology that will be part of SQL Server 2014. I have done a lot of reading about the various internal data structures that Hekaton is using for its storage (mainly Hash …
How Hekaton will impact the RTO of your database
Over the weekend I have encountered a very interesting side effect of Hekaton in SQL Server 2014, which unfortunately impacts your RTO (Recovery Time Objective) of your database in a negative way. As you know, Hekaton creates for every native compiled Table and Stored Procedure a DLL, which contains the native implementation in C code. …
How Hekaton will impact the RTO of your database + read more
