4 Steps to Faster SQL Server Applications

Zenler Player

Your course is loading. Hang tight.

Who is this course for? Preview
Who is Greg ? Preview
Why is indexing such a big issue? Preview
Why are repetitive queries also such an issue? Preview
Why do developers need to care about query performance more than ever? Preview
What will I learn to do in this course? Preview

What you need before you start
Introduction to SDU Tools
Downloading SDU Tools
Create a database and install SDU Tools

Introduction to capturing traces
Using SDU Tools to capture traces
Starting the capture at a later time
Working with traces captured elsewhere (or the sample trace)

Normalized queries vs actual queries
Loading and normalizing a captured trace
Analyzing a loaded trace
Making sense of the numbers

Finding how SQL Server executes a query
Finding and creating missing indexes
Indexes are an overhead
How many indexes are too many?
Rationalizing your indexes
Fixing repetitive queries

How do I learn more about indexing?