SQL Server Performance: Introduction to Query Tuning [2012, ENG] torrent

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

SQL Server Performance: Introduction to Query Tuning

Год выпуска: 2012
Производитель: pluralsight-training.net
Автор: Vinod Kumar, Pinal Dave
Продолжительность: 04:10:31
Тип раздаваемого материала: Видеоурок
Язык: Английский
Описание: Индусы снова в строю!
SQL Server performance tuning is an in-depth topic, and an art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.
[spoiler="Содержание"]
Introduction 00:10:19
Introduction 02:57
Query Tuning 02:37
Demo 04:45

Execution Plan Basics 00:45:51
Introduction 04:00
Demo 05:58
Various Execution Plan Types 03:04
Demo: Execution Plan Types 05:23
Clustered Index 04:22
Demo: Clustered Index 04:07
Non-clustered Index 01:41
Demo: Non-clustered Index 03:49
Key Lookup 00:47
Demo: Key Lookup 03:19
Index Seek vs Index Scan 01:42
Types of Joins 01:53
Demo: Types of Joins 04:33
Summary 01:13

Essential Indexing Techniques 00:36:05
Introduction 03:53
Demo: Basics of Index 04:41
Index Behaviors 00:59
Demo: Included Columns 04:59
Demo: Seek vs Scan vs Lookup 04:58
Demo: WHERE clause and ORDERs of Column 09:34
Demo: Usage of Functions in WHERE clause 04:48
Summary 02:13

Query Design for Performance 00:50:09
Introduction 02:04
EXISTS vs IN vs JOIN 02:48
Demo: EXISTS vs IN vs JOIN 09:56
Common Table Expression (CTE) 01:00
Demo: Common Table Expression (CTE) 04:10
Order of Table and Query Hints 01:14
Demo: Order of Table and Query Hints 05:39
Plan Guide and Parameter Sniffing 01:33
Demo: Plan Guide and Parameter Sniffing 05:33
Dynamic SQL and Performance 01:03
Demo: Dynamic SQL and Performance 04:52
User Defined Functions, Views and Performance 01:56
Demo: UDFs, Views and Performance 07:39
Summary 00:42

Performance Tuning Tools 01:15:06
Introduction 01:41
SSMS Performance Dashboard 01:13
Demo: SSMS Performance Dashboard 10:40
Demo: Error Logs 03:03
Demo: SQL Server Best Practices Analyzer 03:47
Demo: Database Tuning Advisor 06:59
Demo: Perfmon Counters 06:08
Demo: Performance Analysis of Logs (PAL) Tool 06:00
Demo: SQL Space Map 02:20
Demo: SQL Server Profiler 09:05
Demo: SQL Server Extended Events 04:20
SQL Server Wait Stats 03:14
Demo: SQL Server Wait Stats - CXPACKET 05:15
Demo: Wait Stats - Identify Offending Query 02:17
Demo: Dynamic Management Views (DMV) 05:29
Demo: SQLDiag 03:02
Summary 00:33

Tips and Tricks 00:25:49
Introduction 01:12
Demo: Columnstore Index 02:25
Demo: Functions and Computed Columns 01:35
Demo: Cursors and Performance 03:21
Demo: Multi Statement Table Value Functions 03:33
Demo: Stored Procedure and Dynamic Query 02:41
Demo: Stored Procedure and Transaction 02:03
Demo: Stored Procedure and Compilation 03:26
Demo: Performance Tips and Tricks 05:33

Checklist: Performance Tuning 00:07:12
Checklist 07:12
[/spoiler]
Файлы примеров: отсутствуют
Формат видео: WMV
Видео: WMV3, 1024x768, 15 fps, ~165 kbps
Аудио: WMA v2, 44100Hz, 128 kb/s, Stereo
[spoiler="Скриншоты"]

[/spoiler]