Randolph West reports on a change in SQL Server 2014:
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 rate.
Click through to see what SQL Server uses instead when “zeroing” out a log file.