Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
4 Steps to Faster SQL Server Applications
Getting Started
Who is this course for? (1:14)
Who is Greg ? (1:08)
Why is indexing such a big issue? (2:01)
Why are repetitive queries also such an issue? (3:08)
Why do developers need to care about query performance more than ever?
What will I learn to do in this course? (1:45)
Get our free tools
What you need before you start (2:05)
Introduction to SDU Tools (3:00)
Downloading SDU Tools (1:47)
Create a database and install SDU Tools (2:22)
Capture what's happening
Introduction to capturing traces (1:28)
Using SDU Tools to capture traces (2:33)
Starting the capture at a later time (1:02)
Working with traces captured elsewhere (or the sample trace)
Analyze what's going on
Normalized queries vs actual queries (2:04)
Loading and normalizing a captured trace (3:38)
Analyzing a loaded trace (5:22)
Making sense of the numbers
Fix the worst offenders
Finding how SQL Server executes a query (2:26)
Finding and creating missing indexes (4:07)
Indexes are an overhead
How many indexes are too many? (1:45)
Rationalizing your indexes (2:29)
Fixing repetitive queries
Next steps
How do I learn more about indexing? (1:01)
Who is this course for?
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock