Debunk common SQL Server myths and misconceptions in this fast-paced 90-minute conference talk from PASS Data Community Summit. Explore a wide range of topics including data compression, truncate table operations, snapshot isolation, checkpoints, data file shrink, instant file initialization, crash recovery, log files, corruptions, and SSD fragmentation. Learn from Paul's extensive experience helping people on forums, newsgroups, and customer engagements as he clarifies how SQL Server operates and should be managed and maintained. Test your knowledge and see how many myths you can correctly identify in this engaging and informative session.
Overview
Syllabus
Introduction
My name is Parental
kilt
crossdressing
sheep
Jonathan
Data Compression
It depends
truncate table is
minimally logged
proof
rollback
Data File Shrink
Sequel Server
quel Server
Snapshot Isolation
Checkpoints
Dirty Pages
Size of Data Operation
DB Datafile
One to One
One Log File
Multiple Log Files
Instant File initialization
Crash Recovery
Log Size
Log Records
Corruptions
Automatic Page Repair
Check DB
IO Subsystem
Guarantees
Its Getting Late
Log Recovery Model
Temp DB
SSD fragmentation
Taught by
PASS Data Community Summit
