Play by Play: SQL Server Administration with Pinal Dave
By Geoffrey Grosenbach and Pinal Dave
Pinal Dave discusses real-world SQL Server performance tuning and query optimization.
Course info
Level
Advanced
Updated
Jun 20, 2014
Duration
1h 43m
Table of contents
Introduction
Basic Information Gathering
Removing Performance Bottleneck
Index Optimization
Impact of Unused Index
8m
Impact of Clustered Index
5m
Impact of Nonclustered Index
4m
Create Missing Index
5m
Drop Unused Index
3m
Optimize Query With Re-write
Description
Course info
Level
Advanced
Updated
Jun 20, 2014
Duration
1h 43m
Description
Geoffrey Grosenbach sits down with Pinal Dave to see what a SQL Server Admin does in the real world. This Play-by-Play will focus on SQL Server performance tuning. Pinal goes over optimizing queries and fine-tuning the server.
About the author
About the author
Geoffrey is VP of Open Source at Pluralsight. He founded PeepCode and has created numerous courses on Ruby, JavaScript and Shell.
More from the author
More courses by Geoffrey Grosenbach
About the author
Pinal Dave is a Pluralsight Developer Evangelist.
More from the author
More courses by Pinal Dave