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

Learn how common SQL Server myths and misconceptions can lead to performance, availability, and other problems. Applicable from SQL Server 2005 onwards.

  • +

    Course Syllabus

    - 9m 51s

    —Introduction 1m 41s
    —Why is Some Information Incorrect? 2m 22s
    —Why Does Incorrect Information Cause Problems 1m 54s
    —Summary 1m 31s
    —Course Structure 2m 23s
    Performance Myths and Misconceptions
    - 51m 34s

    —Introduction 1m 1s
    —Controlling Instant File Initialization 2m 27s
    —Demo: Enabling Instant File Initialization 2m 47s
    —Temporary Table Abuse 2m 5s
    —Demo: Using Temporary Tables 2m 54s
    —Tempdb Sizing 1m 50s
    —Data Compression 2m 29s
    —Data File Shrinking 2m 40s
    —Demo: Effect of Data File Shrinking 2m 22s
    —Updating Index Key Columns 2m 7s
    —Demo: Updating Index Key Columns 2m 37s
    —Snapshot Isolation 2m 41s
    —Checkpoints 1m 25s
    —NULL Bitmap 2m 40s
    —Tempdb Data Files 3m 1s
    —Solid State Disk Uses 2m 16s
    —Disk Queue Length 1m 24s
    —Page Life Expectancy Threshold 2m 24s
    —NUMA Effect on Page Life Expectancy 1m 26s
    —CXPACKET Waits 2m 36s
    —ASYNC_NETWORK_IO Waits 2m 1s
    —Demo: Wait Statistics 3m 0s
    —Overriding MAXDOP 1m 21s
    Transaction Log Myths and Misconceptions
    - 41m 34s
    Indexing Myths and Misconceptions
    - 18m 23s
    Locking Myths and Misconceptions
    - 21m 31s
    Transact-SQL Myths and Misconceptions
    - 19m 8s
    Backup Myths and Misconceptions
    - 18m 44s
    Restore Myths and Misconceptions
    - 14m 55s
    Corruption Myths and Misconceptions
    - 21m 19s
    High-Availability Myths and Misconceptions
    - 17m 48s

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