Inspect CE feedback for expressions in SQL Server 2025, check compatibility and Query Store, and observe repeated execution evidence.
SQL SERVER – Introduction to SQL Server 2014 In-Memory OLTP
An introduction to In-Memory OLTP in SQL Server 2014, the Hekaton engine that keeps busy tables in memory without losing a record and still runs most T-SQL.
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.
SQL SERVER – Activity Monitor to Identify Blocking – Find Expensive Queries
My friend Jim needed an easy way to find blocking on a live system. Here is how to use Activity Monitor to identify blocking and find expensive queries.