[Pluralsight- training] SQL Server Performance: Indexing Basics (2012) | 234 MB
Genre: Video Training
Indexes are the most crucial objects of the database . They are the first stop for any DBA and developer when it comes to performance tuning. To master the art of performance tuning one has to understand the fundamentals of the indexes how to best apply them. This course is for every DBA and developer who deals with performance tuning and wants to use indexes to improve the performance of server.
Introduction 00:02:02
Introduction 02:02
Fundamentals of Indexing 00:22:18
Introduction 00:58
Index Fundamentals 06:27
Index Fundamentals – Visual Representation 04:19
Demo 08:03
Additional Information 02:01
Summary 00:30
Practical Indexing Implementation Techniques 00:37:18
Introduction 01:48
Primary Key 01:12
Demo: Primary Key 03:42
Over Indexing 00:53
Demo: Over Indexing 02:11
Duplicate Index 00:45
Demo: Duplicate Index 02:39
Clustered Index 01:34
Demo: Clustered Index 02:31
Unique Index 00:37
Demo: Unique Index 04:14
Included Columns 01:04
Demo: Included Columns 04:16
Filtered Index 00:48
Demo: Filtered Index 04:04
Disabled Index 00:45
Demo: Disabled Index 03:38
Summary 00:37
Index Maintenance 00:16:29
Introduction 01:54
Demo: Index Maintenance 06:31
Defragmentation 01:15
Demo: Defragmentation 04:38
Additional Information 00:57
Summary 01:14
Introduction to Columnstore Index 00:08:05
Introduction 00:54
Concepts 02:04
Demo 03:23
Additional Information 00:51
Summary 00:53
Indexing Practical Performance Tips and Tricks 00:24:50
Index and Page Types 01:59
Index and Non Deterministic Columns 01:42
Index and SET Values 01:22
Importance of Clustered Index 01:36
Effect of Compression and Fillfactor 02:52
Index and Functions 03:24
Dynamic Management Views (DMV) – Fillfactor 01:30
Table Scan, Index Scan and Index Seek 02:55
Index and Order of Columns 07:30
Checklist: Index and Performance 00:07:28
Final Checklist 07:28
Download
http://shareflare.net/download/66940.6526ac2e5de4220ebfba1c52eb46/_pluralsight-training__SQL_Server_Performance_-_Indexing_Basics.part1.rar.html
http://shareflare.net/download/29152.24fd8a176d23da445d64afeed6c6/_pluralsight-training__SQL_Server_Performance_-_Indexing_Basics.part2.rar.html
http://shareflare.net/download/70601.71048135400395825c0e90e0a37c/_pluralsight-training__SQL_Server_Performance_-_Indexing_Basics.part3.rar.html
