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.
Play by Play with Pinal Dave: Tuning SQL Server Performance
Play by Play with Pinal Dave was my birthday gift on July 30, 2014: a Pluralsight course that shows how I tune SQL Server performance on a real problem. This post tells why I made it and what each of the five modules covers.
Foreign Keys Without Indexes: Finding and Fixing Slow Deletes
Find foreign keys without indexes, inspect parent-delete plans, and choose leading child-table keys that support relationship checks.
Missing Index Query Text: Linking Suggestions to Their Queries
A missing index suggestion means more when you can see its query. Here is how to link them, trim the text and test the index.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.
Resumable Index Rebuilds: Pausing Maintenance Without Losing Progress
Run a resumable index rebuild with ONLINE and MAX_DURATION, pause and resume it, inspect progress, and weigh edition and log costs.
Moving a Table to Another Filegroup by Rebuilding Its Clustered Index
One statement moves the rows, but large-object data and other indexes stay behind. A small demo shows exactly where everything ends up.