SQL Server 2014

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

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

Choose your Hash Bucket Count very wisely in Hekaton!

Today I have encountered a very simple blog posting where someone was inserting 1 millions of rows into a Hekaton Hash Index of 2048 buckets. Therefore I was running some tests how Hash Collisions in the Hash Buckets will affect the throughput of your Hekaton workload – and the results are very, very interesting. In …

Choose your Hash Bucket Count very wisely in Hekaton! + read more