Why should you backup master database? It holds all logins, system configuration and the details SQL Server needs to reach every other database.
Estimating Table Growth for Next Year From Backup History
Estimate table growth with monthly full backup history, a twelve month forecast, and table space checks that separate evidence from guesses.
SQL SERVER – Shrinking NDF and MDF Files – A Safe Operation
Is shrinking NDF and MDF files safe? A reader asked if it causes data loss. It does not, but I explain why shrinking them is often not a good idea.
SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation
sp_spaceused shows the row count of a table and the disk space reserved. Here is why its numbers looked wrong on AdventureWorks and how @updateusage fixed them.
SQL SERVER – Find Table Row Count Without Using T-SQL and Without Opening Table
An interview question: how do you find a table row count without using T-SQL or opening the table? SSMS table properties show it on the Storage page.
SQL SERVER – Guidelines and Coding Standards Complete List Download
My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.
XML Compression in SQL Server 2022
Use XML compression in SQL Server 2022 to reduce XML storage, inspect partition settings, and compare CPU costs on your own workload.