Dear SQL DBA

Why is My Query Faster on the Second Run?

Nov 24, 2016

25:31

Creator website

Highlights

AI Chapters

Episode notes

Query Rerights - Can I Simplify Optimization?

02:48

Do a Cold Cash Test Against a Development Server?

03:33

How Long Does It Take to Compile a Plan?

02:48

Introduction

3min

Why Memory Is a Big Deal in SQL Servers

3min

How Long Does It Take to Compile a Plan?

3min

Query Store Tracks Compile Time and Execution Plan Components

2min

Compiling a Complex Query

4min

Query Rerights - Can I Simplify Optimization?

3min

Using Memory to Speed Up Query Execution

2min

How to Test a Query Using a New View

3min

Do a Cold Cash Test Against a Development Server?

4min

The first time you test a query it's slow, but when you run it again, it's much faster. Learn how SQL Server uses memory to make the second run much faster.

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.