A SQL Server DBA myth a day
di Paul Randal (1/30) in-flight transactions continue after a failover(2/30) DBCC CHECKDB causes blocking(3/30) instant file initialization can be controlled from within SQL Server(4/30) DDL triggers are INSTEAD OF triggers(5/30) AWE must be enabled on 64-bit servers(6/30) three null bitmap myths(7/30) multiple mirrors and log shipping load delays(8/30) unicorns, rainbows, and online index operations(9/30) data …