A shrink at 4 PM on Friday can block your whole app. See what the low-priority option does, and why shrinking is still a rare tool.
Page Restore: Fixing a Few Corrupt Pages Without a Full Restore
Rehearse page restore on a test database, identify damaged page IDs, apply the backup chain, and verify storage and database consistency.
Reading DBCC SHOW_STATISTICS Step by Step
Read SHOW_STATISTICS headers, density and histogram boundaries, compare estimates with your plan, and query the histogram directly.
Why DBCC SHRINKFILE Crawls and How to Watch Its Progress
Explain why DBCC SHRINKFILE can take hours, monitor percent_complete and waits, and use TRUNCATEONLY before small steps.
Reseed an Identity Column in SQL Server: SQL in Sixty Seconds #051
To reseed an identity column, run DBCC CHECKIDENT with the RESEED option. The tests here show which value comes next after existing rows, DELETE and TRUNCATE, and what happens when the new value collides with a key.
Why Table Size Numbers Disagree: Reserved, Used and Unused Space
Reconcile table size reports by reading reserved, used, data, index, and unused pages from sys.dm_db_partition_stats on SQL Server.
Maintaining SharePoint Content Databases: What the DBA Still Owns
Review SharePoint content databases for CHECKDB, backup history, log growth, recovery model, and a tested site-collection restore.