See the real costs of SELECT * in production code: lost covering indexes, lookups, stale view metadata, broken inserts and wider results.
SQL SERVER – Making Database to Read Only – Changing Database to Read/Write
A reader attached a client database and it showed as Read Only. Two simple ALTER DATABASE scripts switch a database to READ_ONLY and back to READ_WRITE.
SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device . Operating system error 5(Access is denied.)
Msg 3201, cannot open backup device, operating system error 5 (Access is denied). The SQL Server service account needed permission on the disk.
SQL SERVER – TempDB in RAM for Performance
TempDB in RAM needs a review of capacity, support and memory pressure. I compare those costs with the bottleneck it would address.
OFFSET FETCH Paging and Its Deep Page Problem
Use OFFSET FETCH with a unique sort order, compare early and deep page reads, and decide when a cursor based approach fits better.
Rows That Look Identical but Are Not: Finding Hidden Characters
Expose hidden characters with DATALENGTH and UNICODE, clean known whitespace safely, and add a constraint to prevent recurrence.
hierarchyid GetDescendant: Insert Between Siblings
hierarchyid GetDescendant can generate a sibling location before, after or between existing bounds. This read-only example computes paths without inserting records or guaranteeing allocation.