Please enable Javascript, which is required for this site.
sql-server-indexing

SQL Server Performance: Indexing Basics

This course teaches you how to master the art of performance tuning SQL Server by better understanding indexes.

Authored by: Dave , Kumar
Duration: 1h 58m
Level: Intermediate
Released: 3/5/2012
Features: Closed captions
Course Rating:
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using:  {{getCurrentPlayerName()}}  [Change]
expand all | collapse all Progress Duration
This module is unavailableIntroduction
 You have not watched this Module. 00:02:03
Introduction
You have not watched this Clip. 02:03
This module is unavailableFundamentals of Indexing
 You have not watched this Module. 00:22:21
Introduction
You have not watched this Clip. 00:58
Index Fundamentals
You have not watched this Clip. 06:28
Index Fundamentals - Visual Representation
You have not watched this Clip. 04:20
Demo
You have not watched this Clip. 08:03
Additional Information
You have not watched this Clip. 02:02
Summary
You have not watched this Clip. 00:30
This module is unavailablePractical Indexing Implementation Techniques
 You have not watched this Module. 00:37:25
Introduction
You have not watched this Clip. 01:49
Primary Key
You have not watched this Clip. 01:12
Demo: Primary Key
You have not watched this Clip. 03:42
Over Indexing
You have not watched this Clip. 00:53
Demo: Over Indexing
You have not watched this Clip. 02:11
Duplicate Index
You have not watched this Clip. 00:46
Demo: Duplicate Index
You have not watched this Clip. 02:40
Clustered Index
You have not watched this Clip. 01:35
Demo: Clustered Index
You have not watched this Clip. 02:32
Unique Index
You have not watched this Clip. 00:37
Demo: Unique Index
You have not watched this Clip. 04:14
Included Columns
You have not watched this Clip. 01:05
Demo: Included Columns
You have not watched this Clip. 04:16
Filtered Index
You have not watched this Clip. 00:48
Demo: Filtered Index
You have not watched this Clip. 04:04
Disabled Index
You have not watched this Clip. 00:45
Demo: Disabled Index
You have not watched this Clip. 03:39
Summary
You have not watched this Clip. 00:37
This module is unavailableIndex Maintenance
 You have not watched this Module. 00:16:33
Introduction
You have not watched this Clip. 01:54
Demo: Index Maintenance
You have not watched this Clip. 06:32
Defragmentation
You have not watched this Clip. 01:16
Demo: Defragmentation
You have not watched this Clip. 04:39
Additional Information
You have not watched this Clip. 00:58
Summary
You have not watched this Clip. 01:14
This module is unavailableIntroduction to Columnstore Index
 You have not watched this Module. 00:08:06
Introduction
You have not watched this Clip. 00:55
Concepts
You have not watched this Clip. 02:04
Demo
You have not watched this Clip. 03:23
Additional Information
You have not watched this Clip. 00:51
Summary
You have not watched this Clip. 00:53
This module is unavailableIndexing Practical Performance Tips and Tricks
 You have not watched this Module. 00:24:56
Index and Page Types
You have not watched this Clip. 02:00
Index and Non Deterministic Columns
You have not watched this Clip. 01:43
Index and SET Values
You have not watched this Clip. 01:23
Importance of Clustered Index
You have not watched this Clip. 01:36
Effect of Compression and Fillfactor
You have not watched this Clip. 02:52
Index and Functions
You have not watched this Clip. 03:25
Dynamic Management Views (DMV) - Fillfactor
You have not watched this Clip. 01:30
Table Scan, Index Scan and Index Seek
You have not watched this Clip. 02:56
Index and Order of Columns
You have not watched this Clip. 07:31
This module is unavailableChecklist: Index and Performance
 You have not watched this Module. 00:07:29
Final Checklist
You have not watched this Clip. 07:29