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 2019 – How to Turn On or Enable Instant File Initialization?
SQL Server 2019 Configuration Manager provides an interface for instant file initialization. My lab also used it with SQL Server 2017.
How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258
Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve.
Table Variable Deferred Compilation: Before and After SQL Server 2019
Compare table variable deferred compilation at compatibility levels 140 and 150, then decide when a temporary table gives better estimates.
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.