Estimate vector column storage from dimensions, measure DATALENGTH and table allocation, and separate payload bytes from page overhead.
LPIM in Configuration Manager: Enable Lock Pages in Memory
You can set LPIM in Configuration Manager without editing the local security policy by hand. This post shows where the property sits, how to read it from PowerShell, and how to check the result with T-SQL after the restart. It also explains why a memory cap comes first.
SQL SERVER – SQL Azure Managed Instance Restore Error – The Database Was Backed Up on a Server Running Version 15.00.2000
One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation. Let us resolve Restore Error.
ISNUMERIC Function Returns 1 for 12e5: What to Use Instead
The ISNUMERIC function returns 1 for strings that are not plain numbers, such as 12e5, a lone dollar sign and a lone plus. This post shows what it accepts, why, and which tests to use instead. It covers TRY_CAST and its blank string quirk, TRY_PARSE, and the digit pattern checks readers suggest.
OPTION (RECOMPILE) Hint: When a Fresh Plan Pays Off
The OPTION (RECOMPILE) hint tells SQL Server to build a new plan every time a statement runs. This post measures the page reads it saves on skewed data, the compile cost it adds, the filtered index it unlocks, and how to apply it to one statement of a procedure.
Running DBCC CHECKDB on a Restored Copy Instead of Production
Run CHECKDB on a restored copy to validate a recoverable backup, retain the full check output, and understand what remains untested.
GLOBAL_TEMPORARY_TABLE_AUTO_DROP: Keeping ## Tables Alive on Purpose
Understand GLOBAL_TEMPORARY_TABLE_AUTO_DROP, its version and database scope, explicit cleanup, and the risks of shared global tables.