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
SQLServer
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
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
My SQLrally Session about how to measure Index Impact Changes
During the current week I have spoken at 2 SQLrally conferences, once in Stockholm/Sweden, and once in Amsterdam/Netherlands. At both conferences I have presented my brand-new session titled “How to measure Index Impact Changes”. The goal of the session is very easy: imagine you want to change your Indexing Strategy in for your production system, …
My SQLrally Session about how to measure Index Impact Changes + read more
