Snipd home pageGet the app
public
Dear SQL DBA chevron_right

Why is My Query Faster on the Second Run?

Nov 24, 2016
25:31
forum Ask episode
view_agenda Chapters
auto_awesome Transcript
info_circle Episode notes
1
Introduction
00:00 • 3min
chevron_right
2
Why Memory Is a Big Deal in SQL Servers
02:37 • 3min
chevron_right
3
How Long Does It Take to Compile a Plan?
05:24 • 3min
chevron_right
4
Query Store Tracks Compile Time and Execution Plan Components
08:12 • 2min
chevron_right
5
Compiling a Complex Query
10:16 • 4min
chevron_right
6
Query Rerights - Can I Simplify Optimization?
13:51 • 3min
chevron_right
7
Using Memory to Speed Up Query Execution
16:39 • 2min
chevron_right
8
How to Test a Query Using a New View
18:42 • 3min
chevron_right
9
Do a Cold Cash Test Against a Development Server?
21:58 • 4min
chevron_right

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.

HomeTop podcastsPopular guests