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: Why Physical Database Design Matters

Course Summary

This course is about how your database's physical design either takes advantage of or is hindered by the way that the SQL Server platform works; knowing this can give you better long-term scalability, availability, and performance. Choosing the right da

  • +

    Course Syllabus

    ● Introduction
        ◦ Does Physical Database Design Matter?
        ◦ Why is This Course Important?
        ◦ What Does Physical Database Design Mean?
        ◦ Prototyping Makes Perfect
        ◦ Why is This Course Relevant?
        ◦ Why Can I Teach This Course?
        ◦ Course Focus and Structure (1)
        ◦ Course Focus and Structure (2)
    ● Data Types and Row Size
        ◦ Introduction
        ◦ It is Not Just About That Single Column Value
        ◦ Use Common Sense: Do Not Take it Too Far...
        ◦ Column Size and Number of Columns
        ◦ Understanding Rows, Pages, and Storage
        ◦ Data Storage Structure: IN_ROW_DATA
        ◦ Data Storage Structure: ROW_OVERFLOW_DATA
        ◦ Data Storage Structure: LOB_DATA
        ◦ Record Structure
        ◦ Demo: Analyzing Table Structures
        ◦ Demo: Secondary Errors - Insert Error from Poor Column Choice
        ◦ Record Structure: Key Points (1)
        ◦ Record Structure: Key Points (2)
        ◦ Vertical Partitioning (Limited LOB And LOB)
        ◦ Vertical Partitioning: Customer Table
        ◦ Vertical Partitioning Strategies
        ◦ Record Structure and Compression
        ◦ Summary: Column Size and Row Size Matter!
    ● Data Types and Index Size
        ◦ Introduction
        ◦ What Structures Exist for A Table?
        ◦ What About Columnstore Indexes?
        ◦ Table Structure: Heap
        ◦ Demo: Analyzing Heap Structures - Setup
        ◦ Demo: Analyzing Heap Structures
        ◦ Table Structure: Clustered Table
        ◦ Demo: Analyzing Clustered Table Structures - Setup
        ◦ Demo: Analyzing Clustered Table Structures - Part I
        ◦ Demo: Setup sp_SQLskills_SQL2012_helpindex
        ◦ Demo: Analyzing Clustered Table Structures - Part 2
        ◦ Accessing Data Using A Clustered Index
        ◦ Nonclustered Indexes: The Book Analogy
        ◦ Accessing Data Using A Nonclustered Index
        ◦ Clustering Key Usage In Nonclustered Indexes
        ◦ Demo: Analyzing Nonclustered Index Structures
        ◦ Clustering Key Widens Nonclustered Indexes
        ◦ Nonclustered Index Overhead
        ◦ Is it Really that Much Space?
        ◦ Clustered Index Criteria
        ◦ Choose A GOOD Clustering Key
        ◦ Primary Key Does NOT Have to be The Clustering Key
        ◦ Scenario: What is The Real Cost?
        ◦ Scenario: What is In That Key?
        ◦ Scenario: What is The Total Cost?
        ◦ Demo: Analyzing AdventureWorksDW2012.dbo.FactInternetSales
        ◦ Summary: The Effect of Data Type Choice
    ● Data Types and Query Performance
        ◦ Introduction
        ◦ Implicit Conversions
        ◦ Demo: Implicit Conversions
        ◦ More on Implicit Conversions
        ◦ Demo: Finding Implicit Conversions in The Plan Cache
        ◦ Probe Residual
        ◦ Demo: Probe Residual
        ◦ Demo: Finding Probe Residual in The Plan Cache
        ◦ Summary: Inconsistencies in Data Types
        ◦ Just The Tip of The Iceberg
        ◦ Where to go Next?
        ◦ Course Summary


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