A follow-up to my post on hash collisions: DMV queries that help with identifying InMemory OLTP Hash Collisions caused by a poorly chosen bucket count.
SQL SERVER – Finding Waits For Any Session with Extended Event wait_info
It becomes a great win-win situation. Let us learn about Extended Event wait_info in this blog post. Do you think this script will be useful for you?
SQL Server – InMemory OLTP Hash Collisions Performance Overhead
A customer’s InMemory OLTP tables ran slowly because of a very low hash bucket count. Here is the hash collisions performance overhead and how to avoid it.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
SQL SERVER – Updating Data into ColumnStore Index with SQL Server 2012
In SQL Server 2012, INSERT fails with Msg 35330 on a table with a columnstore index. Here is the process for updating data into ColumnStore index.
SQL SERVER – ShowPlan XML Additions for ColumnStore Indexes
How can you tell if a query used a columnstore index and batch processing? Here are the properties SQL Server adds to the ShowPlan XML for ColumnStore indexes.
SQL SERVER InMemory OLTP: Understanding Optimistic Multi-Version Concurrency Concepts
A reader asked what Optimistic Multi-Version Concurrency in InMemory OLTP really means. It sounds simple but is a loaded question, so here is a plain answer.