MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Myths and Misconceptions

Course Summary

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 p

  • +

    Course Syllabus

    ● Introduction
        ◦ Introduction
        ◦ Why is Some Information Incorrect?
        ◦ Why Does Incorrect Information Cause Problems
        ◦ Summary
        ◦ Course Structure
    ● Performance Myths and Misconceptions
        ◦ Introduction
        ◦ Controlling Instant File Initialization
        ◦ Temporary Table Abuse
        ◦ Tempdb Sizing
        ◦ Data Compression
        ◦ Data File Shrinking
        ◦ Updating Index Key Columns
        ◦ Snapshot Isolation
        ◦ Checkpoints
        ◦ NULL Bitmap
        ◦ Tempdb Data Files
        ◦ Solid State Disk Uses
        ◦ Disk Queue Length
        ◦ Page Life Expectancy Threshold
        ◦ NUMA Effect on Page Life Expectancy
        ◦ CXPACKET Waits
        ◦ ASYNC_NETWORK_IO Waits
        ◦ Overriding MAXDOP
    ● Transaction Log Myths and Misconceptions
        ◦ Introduction
        ◦ Log Truncation/Clearing
        ◦ Transaction Log Analysis
        ◦ TRUNCATE TABLE Logging
        ◦ Efficient Logging of Index Operations
        ◦ Multiple Log Files
        ◦ Instant File Initialization
        ◦ Transaction Log Sizing
        ◦ Log Record Removal
        ◦ Log Record Movement
        ◦ Using BULK_LOGGED to Reduce Log Backup Size
        ◦ Log Backup Size vs. Log Size
        ◦ Disaster Recovery and BULK_LOGGED
    ● Indexing Myths and Misconceptions
        ◦ Introduction
        ◦ FILLFACTOR Usage
        ◦ Clustered Index Rebuilds
        ◦ Nonclustered Index Choice
        ◦ SSDs and Fragmentation
        ◦ Removing Heap Fragmentation
        ◦ GUIDs as a Cluster Key Choice
        ◦ Rebuilding Indexes and Statistics
    ● Locking Myths and Misconceptions
        ◦ Introduction
        ◦ Online Index Operations and Blocking
        ◦ Backups and Blocking
        ◦ DBCC CHECKDB and Blocking
        ◦ Lock Escalation
        ◦ Invalid Blocking and Deadlocks
    ● Transact-SQL Myths and Misconceptions
        ◦ Introduction
        ◦ Nested Transactions
        ◦ DDL Triggers
        ◦ SELECT COUNT(*)
        ◦ Physical Record Location
        ◦ Running DMVs in 80 Compatibility Mode
    ● Backup Myths and Misconceptions
        ◦ Introduction
        ◦ Concurrent Data and Log Backups
        ◦ Data Backups and Log Clearing
        ◦ Backup Completion Guarantees
        ◦ Differential Backups
        ◦ Planning a Backup Strategy
        ◦ Restarting the Log Backup Chain
        ◦ Replacing Backups with Database Snapshots
    ● Restore Myths and Misconceptions
        ◦ Introduction
        ◦ Mix-and-Match Filegroups
        ◦ Using WITH STOPAT for Data Backups
        ◦ Restoring to Older Versions of SQL Server
        ◦ Restoring to Non-Enterprise Editions
        ◦ 32-Bit vs. 64-Bit Compatibility
    ● Corruption Myths and Misconceptions
        ◦ Introduction
        ◦ Detaching and Attaching a SUSPECT Database
        ◦ Offloading Consistency Checks
        ◦ Causing Corruption Using T-SQL
        ◦ Enabling Page Checksums
        ◦ Restarting SQL Server to Fix Corruption
        ◦ Disappearing Corruptions
        ◦ Corruption-Free Guarantee
        ◦ Repair Can Fix Everything
        ◦ Repairing System Databases/Tables
        ◦ Transaction Rollbacks
    ● High-Availability Myths and Misconceptions
        ◦ Introduction
        ◦ Database Snapshot Size
        ◦ Database Snapshot Efficiency
        ◦ Database Mirroring Failure Detection
        ◦ Database Mirroring Failover Speed
        ◦ Failover Clustering is the Best High-Availability Technology
        ◦ Multiple Database Mirors
        ◦ Transactions After a Failover
        ◦ Replication is a Valid High-Availability Choice

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top