Size hash index bucket count from distinct keys, inspect empty buckets and chains, rebuild a test index, and choose range indexes wisely.
SQL SERVER – Location of Natively Compiled Stored Procedure and Naming Convention
Why is it called a natively compiled stored procedure when the code is T-SQL? I explain, and show a DMV query that finds where its DLL is loaded from.
SQL SERVER – Beginning In-Memory OLTP with Sample Example
Beginning In-Memory OLTP in SQL Server 2014 is easier than it looks. I explain why we need it in simple words, with a sample example to get you started.
SQL SERVER – How to Setup Delayed Durability for SQL Server 2014?
How do you setup Delayed Durability in SQL Server 2014? Here are three methods, starting at the database level with ALTER DATABASE SET DELAYED_DURABILITY.
SQL SERVER – SSMS: Memory Usage By Memory Optimized Objects Report
Why is SQL Server using all the memory? In-Memory OLTP in SQL Server 2014 makes it trickier. This SSMS report shows memory used by memory optimized objects.
SQL SERVER – SSMS: Memory Consumption Report
‘My SQL Server eats RAM and never gives it back’ is a common complaint. The SSMS Memory Consumption report shows where that memory goes and why.
Memory-Optimized Table Variables
Memory-optimized table variables can avoid tempdb work, but they need a filegroup, indexed table type, memory budget, and workload tests.