SQL Server Why Physical Database Design Matters

File Name

Size

03. Data Types and Index Size/26. Demo Analyzing AdventureWorksDW2012.dbo.FactInternetSales.wmv

33 MB

02. Data Types and Row Size/10. Demo Analyzing Table Structures.wmv

24 MB

04. Data Types and Query Performance/07. Demo Probe Residual.wmv

22 MB

03. Data Types and Index Size/21. Choose A GOOD Clustering Key.wmv

22 MB

03. Data Types and Index Size/06. Demo Analyzing Heap Structures.wmv

19 MB

03. Data Types and Index Size/16. Demo Analyzing Nonclustered Index Structures.wmv

16 MB

03. Data Types and Index Size/10. Demo Setup sp_SQLskills_SQL2012_helpindex.wmv

15 MB

04. Data Types and Query Performance/03. Demo Implicit Conversions.wmv

15 MB

03. Data Types and Index Size/09. Demo Analyzing Clustered Table Structures - Part I.wmv

14 MB

04. Data Types and Query Performance/08. Demo Finding Probe Residual in The Plan Cache.wmv

14 MB

03. Data Types and Index Size/05. Demo Analyzing Heap Structures - Setup.wmv

12 MB

03. Data Types and Index Size/08. Demo Analyzing Clustered Table Structures - Setup.wmv

10 MB

02. Data Types and Row Size/11. Demo Secondary Errors - Insert Error from Poor Column Choice.wmv

8.8 MB

03. Data Types and Index Size/15. Clustering Key Usage In Nonclustered Indexes.wmv

8.5 MB

01. Introduction/03. What Does Physical Database Design Mean .wmv

8.2 MB

03. Data Types and Index Size/20. Clustered Index Criteria.wmv

8.0 MB

02. Data Types and Row Size/15. Vertical Partitioning Customer Table.wmv

7.7 MB

02. Data Types and Row Size/01. Introduction.wmv

7.5 MB

04. Data Types and Query Performance/05. Demo Finding Implicit Conversions in The Plan Cache.wmv

7.4 MB

02. Data Types and Row Size/09. Record Structure.wmv

7.2 MB

01. Introduction/04. Prototyping Makes Perfect.wmv

6.7 MB

02. Data Types and Row Size/06. Data Storage Structure IN_ROW_DATA.wmv

6.7 MB

03. Data Types and Index Size/19. Is it Really that Much Space .wmv

6.0 MB

02. Data Types and Row Size/07. Data Storage Structure ROW_OVERFLOW_DATA.wmv

6.0 MB

03. Data Types and Index Size/11. Demo Analyzing Clustered Table Structures - Part 2.wmv

5.5 MB

03. Data Types and Index Size/02. What Structures Exist for A Table .wmv

5.5 MB

01. Introduction/01. Does Physical Database Design Matter .wmv

5.4 MB

02. Data Types and Row Size/08. Data Storage Structure LOB_DATA.wmv

5.4 MB

04. Data Types and Query Performance/01. Introduction.wmv

5.0 MB

02. Data Types and Row Size/17. Record Structure and Compression.wmv

4.9 MB

02. Data Types and Row Size/03. Use Common Sense Do Not Take it Too Far....wmv

4.8 MB

01. Introduction/06. Why Can I Teach This Course .wmv

4.6 MB

03. Data Types and Index Size/07. Table Structure Clustered Table.wmv

4.6 MB

04. Data Types and Query Performance/02. Implicit Conversions.wmv

4.6 MB

02. Data Types and Row Size/14. Vertical Partitioning (Limited LOB And LOB).wmv

4.5 MB

03. Data Types and Index Size/17. Clustering Key Widens Nonclustered Indexes.wmv

4.4 MB

02. Data Types and Row Size/13. Record Structure Key Points (2).wmv

4.3 MB

03. Data Types and Index Size/18. Nonclustered Index Overhead.wmv

4.3 MB

03. Data Types and Index Size/14. Accessing Data Using A Nonclustered Index.wmv

4.3 MB

02. Data Types and Row Size/02. It is Not Just About That Single Column Value.wmv

4.2 MB

03. Data Types and Index Size/24. Scenario What is In That Key .wmv

4.0 MB

01. Introduction/08. Course Focus and Structure (2).wmv

4.0 MB

01. Introduction/05. Why is This Course Relevant .wmv

3.9 MB

02. Data Types and Row Size/05. Understanding Rows, Pages, and Storage.wmv

3.9 MB

03. Data Types and Index Size/12. Accessing Data Using A Clustered Index.wmv

3.8 MB

02. Data Types and Row Size/12. Record Structure Key Points (1).wmv

3.8 MB

03. Data Types and Index Size/03. What About Columnstore Indexes .wmv

3.7 MB

04. Data Types and Query Performance/06. Probe Residual.wmv

3.7 MB

02. Data Types and Row Size/16. Vertical Partitioning Strategies.wmv

3.6 MB

04. Data Types and Query Performance/10. Just The Tip of The Iceberg.wmv

3.5 MB

03. Data Types and Index Size/13. Nonclustered Indexes The Book Analogy.wmv

3.5 MB

04. Data Types and Query Performance/12. Course Summary.wmv

3.5 MB

02. Data Types and Row Size/04. Column Size and Number of Columns.wmv

3.4 MB

01. Introduction/02. Why is This Course Important .wmv

3.4 MB

03. Data Types and Index Size/25. Scenario What is The Total Cost .wmv

3.2 MB

04. Data Types and Query Performance/09. Summary Inconsistencies in Data Types.wmv

3.1 MB

03. Data Types and Index Size/01. Introduction.wmv

2.9 MB

03. Data Types and Index Size/23. Scenario What is The Real Cost .wmv

2.9 MB

01. Introduction/07. Course Focus and Structure (1).wmv

2.9 MB

03. Data Types and Index Size/04. Table Structure Heap.wmv

2.8 MB

03. Data Types and Index Size/27. Summary The Effect of Data Type Choice.wmv

2.6 MB

03. Data Types and Index Size/22. Primary Key Does NOT Have to be The Clustering Key.wmv

2.6 MB

04. Data Types and Query Performance/11. Where to go Next .wmv

2.5 MB

02. Data Types and Row Size/18. Summary Column Size and Row Size Matter!.wmv

2.5 MB

04. Data Types and Query Performance/04. More on Implicit Conversions.wmv

1.8 MB

sqlserver-why-physical-db-design-matters.zip

926 kB