2013
Pluralsight
Kimberly L. Tripp
3h 56m
English

This course shows how you to choose the right data types applicable to SQL Server developers and anyone who is responsible for designing and creating SQL Server tables and indexes, from SQL Server 2005 onward

-01. Introduction
01. Does Physical Database Design Matter .wmv
02. Why is This Course Important .wmv
03. What Does Physical Database Design Mean .wmv
04. Prototyping Makes Perfect.wmv
05. Why is This Course Relevant .wmv
06. Why Can I Teach This Course .wmv
07. Course Focus and Structure (1).wmv
08. Course Focus and Structure (2).wmv

-02. Data Types and Row Size
01. Introduction.wmv
02. It is Not Just About That Single Column Value.wmv
03. Use Common Sense Do Not Take it Too Far....wmv
04. Column Size and Number of Columns.wmv
05. Understanding Rows, Pages, and Storage.wmv
06. Data Storage Structure IN_ROW_DATA.wmv
07. Data Storage Structure ROW_OVERFLOW_DATA.wmv
08. Data Storage Structure LOB_DATA.wmv
09. Record Structure.wmv
10. Demo Analyzing Table Structures.wmv
11. Demo Secondary Errors - Insert Error from Poor Column Choice.wmv
12. Record Structure Key Points (1).wmv
13. Record Structure Key Points (2).wmv
14. Vertical Partitioning (Limited LOB And LOB).wmv
15. Vertical Partitioning Customer Table.wmv
16. Vertical Partitioning Strategies.wmv
17. Record Structure and Compression.wmv
18. Summary Column Size and Row Size Matter!.wmv

-03. Data Types and Index Size
01. Introduction.wmv
02. What Structures Exist for A Table .wmv
03. What About Columnstore Indexes .wmv
04. Table Structure Heap.wmv
05. Demo Analyzing Heap Structures - Setup.wmv
06. Demo Analyzing Heap Structures.wmv
07. Table Structure Clustered Table.wmv
08. Demo Analyzing Clustered Table Structures - Setup.wmv
09. Demo Analyzing Clustered Table Structures - Part I.wmv
10. Demo Setup sp_SQLskills_SQL2012_helpindex.wmv
11. Demo Analyzing Clustered Table Structures - Part 2.wmv
12. Accessing Data Using A Clustered Index.wmv
13. Nonclustered Indexes The Book Analogy.wmv
14. Accessing Data Using A Nonclustered Index.wmv
15. Clustering Key Usage In Nonclustered Indexes.wmv
16. Demo Analyzing Nonclustered Index Structures.wmv
17. Clustering Key Widens Nonclustered Indexes.wmv
18. Nonclustered Index Overhead.wmv
19. Is it Really that Much Space .wmv
20. Clustered Index Criteria.wmv
21. Choose A GOOD Clustering Key.wmv
22. Primary Key Does NOT Have to be The Clustering Key.wmv
23. Scenario What is The Real Cost .wmv
24. Scenario What is In That Key .wmv
25. Scenario What is The Total Cost .wmv
26. Demo Analyzing AdventureWorksDW2012.dbo.FactInternetSales.wmv
27. Summary The Effect of Data Type Choice.wmv

-04. Data Types and Query Performance
01. Introduction.wmv
02. Implicit Conversions.wmv
03. Demo Implicit Conversions.wmv
04. More on Implicit Conversions.wmv
05. Demo Finding Implicit Conversions in The Plan Cache.wmv
06. Probe Residual.wmv
07. Demo Probe Residual.wmv
08. Demo Finding Probe Residual in The Plan Cache.wmv
09. Summary Inconsistencies in Data Types.wmv
10. Just The Tip of The Iceberg.wmv
11. Where to go Next .wmv
12. Course Summary.wmv

http://pluralsight.com/training/

Download File Size:376.35 MB

---