misconceptions Archives

Zeroing out a transaction log file does not use zeroes

by Randolph
March 31, 2021September 16, 2022

I’ve been doing SQLskills training recently, and Paul Randal (blog | Twitter) reminded our class that zeroing out a transaction log file does not use zeroes (0x00). Well, not since SQL Server 2014 at any…

T-SQL Tuesday Retrospective #011: Misconceptions

by Randolph
March 10, 2021September 16, 2022

(If you would like to read the previous T-SQL Tuesday Retrospective entries, visit this link.) In October 2010, Sankar Reddy asked us which misconceptions we’ve been labouring under when it comes to SQL Server: The…