Please enable Javascript, which is required for this site.
sqlserver-myths

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.

Authored by: Paul Randal
Duration: 3h 54m
Level: Intermediate
Released: 6/6/2012
Features: Closed captions
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using:  {{getCurrentPlayerName()}}  [Change]
expand all | collapse all Progress Duration
This module is unavailableIntroduction
 You have not watched this Module. 00:09:51
Introduction
You have not watched this Clip. 01:41
Why is Some Information Incorrect?
You have not watched this Clip. 02:22
Why Does Incorrect Information Cause Problems
You have not watched this Clip. 01:54
Summary
You have not watched this Clip. 01:31
Course Structure
You have not watched this Clip. 02:23
This module is unavailablePerformance Myths and Misconceptions
 You have not watched this Module. 00:51:34
Introduction
You have not watched this Clip. 01:01
Controlling Instant File Initialization
You have not watched this Clip. 02:27
Demo: Enabling Instant File Initialization
You have not watched this Clip. 02:47
Temporary Table Abuse
You have not watched this Clip. 02:05
Demo: Using Temporary Tables
You have not watched this Clip. 02:54
Tempdb Sizing
You have not watched this Clip. 01:50
Data Compression
You have not watched this Clip. 02:29
Data File Shrinking
You have not watched this Clip. 02:40
Demo: Effect of Data File Shrinking
You have not watched this Clip. 02:22
Updating Index Key Columns
You have not watched this Clip. 02:07
Demo: Updating Index Key Columns
You have not watched this Clip. 02:37
Snapshot Isolation
You have not watched this Clip. 02:41
Checkpoints
You have not watched this Clip. 01:25
NULL Bitmap
You have not watched this Clip. 02:40
Tempdb Data Files
You have not watched this Clip. 03:01
Solid State Disk Uses
You have not watched this Clip. 02:16
Disk Queue Length
You have not watched this Clip. 01:24
Page Life Expectancy Threshold
You have not watched this Clip. 02:24
NUMA Effect on Page Life Expectancy
You have not watched this Clip. 01:26
CXPACKET Waits
You have not watched this Clip. 02:36
ASYNC_NETWORK_IO Waits
You have not watched this Clip. 02:01
Demo: Wait Statistics
You have not watched this Clip. 03:00
Overriding MAXDOP
You have not watched this Clip. 01:21
This module is unavailableTransaction Log Myths and Misconceptions
 You have not watched this Module. 00:41:34
Introduction
You have not watched this Clip. 00:58
Log Truncation/Clearing
You have not watched this Clip. 01:42
Transaction Log Analysis
You have not watched this Clip. 01:50
Demo: Analyzing the Transaction Log
You have not watched this Clip. 05:42
TRUNCATE TABLE Logging
You have not watched this Clip. 02:40
Efficient Logging of Index Operations
You have not watched this Clip. 01:52
Demo: Showing Efficient Logging
You have not watched this Clip. 02:43
Multiple Log Files
You have not watched this Clip. 01:41
Instant File Initialization
You have not watched this Clip. 01:47
Transaction Log Sizing
You have not watched this Clip. 03:25
Log Record Removal
You have not watched this Clip. 01:26
Log Record Movement
You have not watched this Clip. 01:23
Using BULK_LOGGED to Reduce Log Backup Size
You have not watched this Clip. 02:21
Demo: Log Backup Size Using BULK_LOGGED
You have not watched this Clip. 02:25
Log Backup Size vs. Log Size
You have not watched this Clip. 01:51
Disaster Recovery and BULK_LOGGED
You have not watched this Clip. 01:37
Demo: Disaster Recovery and BULK_LOGGED
You have not watched this Clip. 06:11
This module is unavailableIndexing Myths and Misconceptions
 You have not watched this Module. 00:18:23
Introduction
You have not watched this Clip. 00:56
FILLFACTOR Usage
You have not watched this Clip. 01:57
Clustered Index Rebuilds
You have not watched this Clip. 01:49
Nonclustered Index Choice
You have not watched this Clip. 02:11
SSDs and Fragmentation
You have not watched this Clip. 02:08
Removing Heap Fragmentation
You have not watched this Clip. 01:37
GUIDs as a Cluster Key Choice
You have not watched this Clip. 02:07
Demo: GUID Cluster Keys
You have not watched this Clip. 04:21
Rebuilding Indexes and Statistics
You have not watched this Clip. 01:17
This module is unavailableLocking Myths and Misconceptions
 You have not watched this Module. 00:21:31
Introduction
You have not watched this Clip. 00:42
Online Index Operations and Blocking
You have not watched this Clip. 02:04
Demo: Locks held by Online Index Rebuild
You have not watched this Clip. 04:14
Backups and Blocking
You have not watched this Clip. 02:00
DBCC CHECKDB and Blocking
You have not watched this Clip. 01:53
Lock Escalation
You have not watched this Clip. 01:55
Demo: Lock Escalation
You have not watched this Clip. 05:32
Invalid Blocking and Deadlocks
You have not watched this Clip. 01:42
NOLOCK and READ UNCOMMITTED
You have not watched this Clip. 01:29
This module is unavailableTransact-SQL Myths and Misconceptions
 You have not watched this Module. 00:19:08
Introduction
You have not watched this Clip. 00:44
Nested Transactions
You have not watched this Clip. 02:12
Demo: Nested Transactions
You have not watched this Clip. 02:47
DDL Triggers
You have not watched this Clip. 01:28
SELECT COUNT(*)
You have not watched this Clip. 02:19
Demo: SELECT COUNT (*)
You have not watched this Clip. 02:50
Physical Record Location
You have not watched this Clip. 02:05
DEMO: Physical Record Location
You have not watched this Clip. 02:54
Running DMVs in 80 Compatibility Mode
You have not watched this Clip. 01:49
This module is unavailableBackup Myths and Misconceptions
 You have not watched this Module. 00:18:44
Introduction
You have not watched this Clip. 00:45
Concurrent Data and Log Backups
You have not watched this Clip. 01:21
Data Backups and Log Clearing
You have not watched this Clip. 01:07
Demo: When Does the Log Clear
You have not watched this Clip. 04:40
Backup Completion Guarantees
You have not watched this Clip. 02:14
Differential Backups
You have not watched this Clip. 01:07
Planning a Backup Strategy
You have not watched this Clip. 01:39
Restarting the Log Backup Chain
You have not watched this Clip. 01:11
Demo: Log Backup Chain
You have not watched this Clip. 02:20
Replacing Backups with Database Snapshots
You have not watched this Clip. 02:20
This module is unavailableRestore Myths and Misconceptions
 You have not watched this Module. 00:14:55
Introduction
You have not watched this Clip. 00:55
Mix-and-Match Filegroups
You have not watched this Clip. 01:53
Demo: Filegroup Restores
You have not watched this Clip. 02:53
Using WITH STOPAT for Data Backups
You have not watched this Clip. 01:19
Restoring to Older Versions of SQL Server
You have not watched this Clip. 02:05
Demo: Down-level Restore
You have not watched this Clip. 02:13
Restoring to Non-Enterprise Editions
You have not watched this Clip. 02:16
32-Bit vs. 64-Bit Compatibility
You have not watched this Clip. 01:21
This module is unavailableCorruption Myths and Misconceptions
 You have not watched this Module. 00:21:19
Introduction
You have not watched this Clip. 00:58
Detaching and Attaching a SUSPECT Database
You have not watched this Clip. 01:55
Offloading Consistency Checks
You have not watched this Clip. 01:54
Causing Corruption Using T-SQL
You have not watched this Clip. 01:07
Enabling Page Checksums
You have not watched this Clip. 01:44
DBCC CHECKDB vs. BACKUP ... WITH CHECKSUM
You have not watched this Clip. 01:13
Restarting SQL Server to Fix Corruption
You have not watched this Clip. 01:17
Disappearing Corruptions
You have not watched this Clip. 02:13
Corruption-Free Guarantee
You have not watched this Clip. 01:00
Repair Can Fix Everything
You have not watched this Clip. 02:04
Repairing System Databases/Tables
You have not watched this Clip. 01:59
Transaction Rollbacks
You have not watched this Clip. 01:44
Demo: Transaction Rollbacks
You have not watched this Clip. 02:11
This module is unavailableHigh-Availability Myths and Misconceptions
 You have not watched this Module. 00:17:48
Introduction
You have not watched this Clip. 00:52
Database Snapshot Size
You have not watched this Clip. 02:21
Database Snapshot Efficiency
You have not watched this Clip. 01:58
Demo: Database Snapshot Memory Usage
You have not watched this Clip. 04:36
Database Mirroring Failure Detection
You have not watched this Clip. 02:14
Database Mirroring Failover Speed
You have not watched this Clip. 01:23
Failover Clustering is the Best High-Availability Technology
You have not watched this Clip. 01:11
Multiple Database Mirors
You have not watched this Clip. 00:40
Transactions After a Failover
You have not watched this Clip. 01:03
Replication is a Valid High-Availability Choice
You have not watched this Clip. 01:30