Updating Statistics in SQL Server
Автор: Kendra Little
Загружено: 2016-04-18
Просмотров: 6440
What are statistics? How often should you update them? Do you need a trace flag to make this easier? Join Kendra Little to find out.
Table of Contents:
00:11 - Hi, I’m Kendra
00:35 - I always kinda hated Aristotle
01:22 - I learned about stats because of performance problems
02:48 - We had an “ascending date key” problem
04:33 - How we fixed it
05:27 - I got a little “golden hammery”
07:25 - We experimented creating stats
11:27 - We learned to drop stats when they didn’t help
12:32 - Maintenance became excessive
14:33 - “What happens if we stop running these stats update jobs?”
15:29 - I’ve found problems on small databases
16:57 - I realized:Updating stats to solve problems is essentially reactive
17:11 - Reactive solutions rarely satisfy
17:28 - I became conservative
19:19 - Trace Flag 2371 is going mainstream
20:05 - These days, I’m more moderate
20:38 - Moderate approach to updating stats
22:10 - Practically speaking…
23:45 - When jobs load batches of data
24:40 - If you diagnose slow queries due to out of date stats
26:08 - LittleKendra.com/recommends/stats
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
![[2026] Feeling Good Mix - English Deep House, Vocal House, Nu Disco | Emotional / Intimate Mood](https://imager.clipsaver.ru/cxLdtvzf2sI/max.jpg)
