SQL Server: Myths and Misconceptions
Learn how common SQL Server myths and misconceptions can lead to performance, availability, and other problems. Applicable from SQL Server 2005 onwards.
What you'll learn
There is so much information online about SQL Server, however much of it is inaccurate to some degree. In this course, you will learn the truth behind more than 80 myths and misconceptions about SQL Server that can cause you performance and availability problems - from someone who wrote the SQL Server code. This course is perfect for developers and DBAs who have been struggling to make sense of conflicting information about SQL Server. The information in the course applies to all versions from SQL Server 2005 onwards.
Table of contents
- Introduction 1m
- Controlling Instant File Initialization 2m
- Demo: Enabling Instant File Initialization 3m
- Temporary Table Abuse 2m
- Demo: Using Temporary Tables 3m
- Tempdb Sizing 2m
- Data Compression 2m
- Data File Shrinking 3m
- Demo: Effect of Data File Shrinking 2m
- Updating Index Key Columns 2m
- Demo: Updating Index Key Columns 3m
- Snapshot Isolation 3m
- Checkpoints 1m
- NULL Bitmap 3m
- Tempdb Data Files 3m
- Solid State Disk Uses 2m
- Disk Queue Length 1m
- Page Life Expectancy Threshold 2m
- NUMA Effect on Page Life Expectancy 1m
- CXPACKET Waits 3m
- ASYNC_NETWORK_IO Waits 2m
- Demo: Wait Statistics 3m
- Overriding MAXDOP 1m
- Introduction 1m
- Log Truncation/Clearing 2m
- Transaction Log Analysis 2m
- Demo: Analyzing the Transaction Log 6m
- TRUNCATE TABLE Logging 3m
- Efficient Logging of Index Operations 2m
- Demo: Showing Efficient Logging 3m
- Multiple Log Files 2m
- Instant File Initialization 2m
- Transaction Log Sizing 3m
- Log Record Removal 1m
- Log Record Movement 1m
- Using BULK_LOGGED to Reduce Log Backup Size 2m
- Demo: Log Backup Size Using BULK_LOGGED 2m
- Log Backup Size vs. Log Size 2m
- Disaster Recovery and BULK_LOGGED 2m
- Demo: Disaster Recovery and BULK_LOGGED 6m
- Introduction 1m
- Concurrent Data and Log Backups 1m
- Data Backups and Log Clearing 1m
- Demo: When Does the Log Clear 5m
- Backup Completion Guarantees 2m
- Differential Backups 1m
- Planning a Backup Strategy 2m
- Restarting the Log Backup Chain 1m
- Demo: Log Backup Chain 2m
- Replacing Backups with Database Snapshots 2m
- Introduction 1m
- Detaching and Attaching a SUSPECT Database 2m
- Offloading Consistency Checks 2m
- Causing Corruption Using T-SQL 1m
- Enabling Page Checksums 2m
- DBCC CHECKDB vs. BACKUP ... WITH CHECKSUM 1m
- Restarting SQL Server to Fix Corruption 1m
- Disappearing Corruptions 2m
- Corruption-Free Guarantee 1m
- Repair Can Fix Everything 2m
- Repairing System Databases/Tables 2m
- Transaction Rollbacks 2m
- Demo: Transaction Rollbacks 2m
- Introduction 1m
- Database Snapshot Size 2m
- Database Snapshot Efficiency 2m
- Demo: Database Snapshot Memory Usage 5m
- Database Mirroring Failure Detection 2m
- Database Mirroring Failover Speed 1m
- Failover Clustering is the Best High-Availability Technology 1m
- Multiple Database Mirors 1m
- Transactions After a Failover 1m
- Replication is a Valid High-Availability Choice 2m
About the author
Paul is the CEO of SQLskills.com, a Microsoft Regional Director and a SQL Server MVP. He worked on the SQL Server Storage Engine team at Microsoft from 1999 to 2007. Among other things, he wrote DBCC CHECKDB/repair for SQL Server 2005 and was responsible for the Core Storage Engine during SQL Server 2008 development. Since leaving Microsoft, Paul has been a full-time consultant and trainer on SQL Server around the world, including authoring and teaching the prestigious Microsoft Certified Mast... more