You cannot Delete a Single Table by editing a SQL Server backup file. I keep the original backup intact.
SQL SERVER – Puzzle – Shortest Code to Produce the Number 1000000000 (One Billion)
This shortest code puzzle asks for 1000000000 without writing that literal or using arithmetic operators. The earlier zero puzzle brought roughly 700 valid answers.
SQL SERVER – The SaveToSQLServer Method has Encountered OLE DB Error Code 0x80040E4D
My relationship with existing clients, I provide quick help to them on simple issues. Let us learn the error related to SaveToSQLServer.
How to Enforce Password Policy of Windows to SQL Server? – Interview Question of the Week #142
SQL Server logins follow Windows password rules by default. If a login has it turned off, here is a simple script to Enforce Password Policy again.
SQL SERVER – How to Enable Backup Compression On by Default
Tired of typing WITH COMPRESSION on every backup? Here is how to Enable Backup Compression on by default for the whole SQL Server instance.
SQL SERVER – What Are Ghost Records and How to Clean Them Up?
Ghost Records are logically deleted index records waiting for physical cleanup. I investigate their context before recommending an intervention.
Querying a Histogram With sys.dm_db_stats_histogram Instead of DBCC
Query sys.dm_db_stats_histogram to inspect statistics steps, compare stored estimates with data, and identify values beyond the last step.