A short pattern can run a long CPU bill. Here is why REGEXP_LIKE scans, and how a plain prefix filter gives the index something to seek.
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.
Scalar UDF Inlining: When Old Functions Suddenly Get Fast
Check scalar UDF inlining eligibility, database settings, function options, and execution plans before claiming a performance improvement.
Top Resource Consumers in Query Store
Top resource consumers in Query Store show CPU, duration, and reads by query and plan, so tuning starts with workload impact.
Reading the Top Five Wait Types on Your Server
Top five wait types become useful when you filter background waits, measure changes over time, and connect them to active work.
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.