Overview
Explore common SQL Server myths and misconceptions in this comprehensive conference talk from PASS Data Community Summit. Delve into topics such as non-logged operations, potential corruption from interrupted shrinks or rebuilds, overriding server MAXDOP settings, and efficient row count retrieval methods. Learn about database snapshots, transaction logs, instant file initialization, online index operations, lock escalation, index rebuilds, failure detection, database mirroring, nonclustered indexes, failover clustering, concurrent data log backups, full log backups, compatibility modes, corruption, and restoration processes. Gain valuable insights from Paul Randall's extensive experience in debunking persistent SQL Server myths, enhancing your understanding of how SQL Server operates and should be managed and maintained.
Syllabus
Intro
Paul Randall
Why is this important
True or False
Database Snapshot
Transaction Log
Instant File Initialization
Online Index Operations
Stop Act
Check D
Index Fill Factor
Lock Escalation
Index Rebuild
Failure Detection
Database Mirroring
Nonclustered Index
failover clustering
concurrent data log backups
full log backup
compat mode
corruption
restoration
nested transactions
Taught by
PASS Data Community Summit