Size hash index bucket count from distinct keys, inspect empty buckets and chains, rebuild a test index, and choose range indexes wisely.
SQL SERVER – Extension of the SQL Server Natively Compiled Stored Procedures
What are the .c, .dll, .obj and .pdb files created for Natively Compiled Stored Procedures in SQL Server 2014? A quick list of each extension and what it does.
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.
In-Memory OLTP in SQL Server: Memory-Optimized Tables Explained
In-Memory OLTP stores selected tables in memory and uses row versions instead of locks. This post builds a small demo database, compares a disk table with two memory-optimized tables, and tests a natively compiled procedure. It also covers durability, bucket counts and memory use.
Natively Compiled Procedures: ATOMIC Blocks and T-SQL Limits
Native procedures check every statement when you create them. Build a tiny one and see which habits it will not accept.
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.