SQL Server: Why Physical Database Design Matters [2013, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

SQL Server: Why Physical Database Design Matters

Год выпуска: 2013
Производитель: Pluralsight
Сайт производителя: http://pluralsight.com
Автор: Kimberly L. Tripp
Продолжительность: 3h 56m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: 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

Этот курс показывает, как правильно выбрать типы данных, применимых к SQL сервера разработчиков и тех, кто отвечает за разработку и создание таблиц SQL сервера и индексы, от SQL Server 2005 вперед [via http://translate.google.com ]
[spoiler="Содержание"]
│ sqlserver-why-physical-db-design-matters.zip
│
├───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
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
[spoiler="audio\video"]
General
Complete name : C:\02. Data Types and Row Size\02. It is Not Just About That Single Column Value.wmv
Format : Windows Media
File size : 4.15 MiB
Duration : 2mn 47s
Overall bit rate mode : Variable
Overall bit rate : 208 Kbps
Maximum Overall bit rate : 268 Kbps
Movie name : recording1
Performer :
Encoded date : UTC 2013-09-13 14:12:17.929

Video
ID : 2
Format : VC-1
Format profile : MP@HL
Codec ID : WMV3
Codec ID/Info : Windows Media Video 9
Codec ID/Hint : WMV3
Description of the codec : Windows Media Video 9
Duration : 2mn 47s
Bit rate mode : Variable
Bit rate : 28.4 Kbps
Width : 1 024 pixels
Height : 768 pixels
Display aspect ratio : 4:3
Frame rate : 15.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Compression mode : Lossy
Bits/(Pixel*Frame) : 0.002
Stream size : 580 KiB (14%)
Language : English (US)

Audio
ID : 1
Format : WMA
Format version : Version 2
Codec ID : 161
Codec ID/Info : Windows Media Audio
Description of the codec : Windows Media Audio 9.2 - 128 kbps, 44 kHz, stereo (A/V) 1-pass CBR
Duration : 2mn 47s
Bit rate mode : Constant
Bit rate : 128 Kbps
Channel(s) : 2 channels
Sampling rate : 44.1 KHz
Bit depth : 16 bits
Stream size : 2.56 MiB (62%)
Language : English (US)
[/spoiler]
[spoiler="Скриншоты"]

[/spoiler]