Creating a login in SSMS failed with Msg 1038: an object or column name is missing or empty. Profiler showed the real cause. Here is what went wrong.
SQL SERVER – RETAINDAYS Does Not Delete Backup After x Days
RETAINDAYS sets backup expiration for overwrite checks, without deleting the file. I keep SQL expiration separate from Windows file cleanup.
SQL SERVER – 5 Don’ts When Database Corruption is Detected
Here is an email I received about database corruption and that has lead me to write this quick blog post about database corruption.
SQL SERVER – Unable to Start SQL Server – TDSSNIClient Initialization Failed with Error 0x2, Status Code 0x38
SQL Server would not start: TDSSNIClient initialization failed with error 0x2, status code 0x38. Process Monitor and the SuperSocketNetLib key helped.
How to Create Primary Key Without ANY Index? – Interview Question of the Week #143
Question: How to create primary key without ANY index? SQL Server builds a clustered or nonclustered index for every primary key, so here is the answer.
How Readable Secondary Replicas Build Their Own Statistics
Learn why readable secondary replicas create temporary statistics in tempdb, how to find them, and when the primary needs a permanent statistic.
Reading a Benchmark Somebody Else Published
Read a database benchmark by checking workload rules, hardware, durability, latency, pricing scope, and whether the test can be repeated.