Pluralsight SQL Server Performance Indexing Basics
Category: Tutorials
- views: 1 579
- date: 9 March 2012
- posted by: auto-im
[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
We need your support!
Make a donation to help us stay online
Bitcoin (BTC)
bc1q08g9d22cxkawsjlf8etuek2pc9n2a3hs4cdrld
Bitcoin Cash (BCH)
qqvwexzhvgauxq2apgc4j0ewvcak6hh6lsnzmvtkem
Ethereum (ETH)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
Litecoin (LTC)
ltc1qt6g2trfv9tjs4qj68sqc4uf0ukvc9jpnsyt59u
USDT (ERC20)
0xb55513D2c91A6e3c497621644ec99e206CDaf239
USDT (TRC20)
TYdPNrz7v1P9riWBWZ317oBgJueheGjATm
Information |
|||
 |
Users of GUESTS are not allowed to comment this publication. | ||