Updating Statistics in SQL Server скачать в хорошем качестве

Updating Statistics in SQL Server

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