While reading about server memory options, I learned the lowest value you can set for max server memory is 16 MB. Anything lower is reset to 16 MB.
SQL SERVER – List of all the Views from Database
Hundreds of Views and no idea which are indexed? A quick query on sys.views lists every view with its schema and whether it is indexed or indexable.
Resumable ADD CONSTRAINT in SQL Server 2022: Pausing a Primary Key Build
Use resumable ADD CONSTRAINT in SQL Server 2022 to pause a key build, inspect progress, resume safely, and understand abort behavior.
hierarchyid GetLevel: Count the Path Depth
hierarchyid GetLevel identifies depth within a logical path. The read-only example distinguishes the root, children, grandchildren and a fractional sibling label.
SQL SERVER – Corrupted Backup File and Unsuccessful Restore
Called in to tune an OLTP server, I ended up helping a Jr. DBA whose restore kept failing. Here is the story of that corrupted backup file.
SQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
Two DISK targets in one BACKUP command split the file, they do not copy it. Learn how a mirrored database backup takes multiple backups in a single command.
Stored Totals: Find Drift Before Repairing It
Stored totals can drift from their authoritative line amounts. This private demonstration finds two mismatches, retains empty orders and accepts valid credits. It checks decimal range before a private repair and explains why concurrency needs separate proof.