Prev: Sacramento, CA SQL Server group
Next: Repair SQL Corrupt database
From: Jefft on 28 Feb 2010 00:30
I have the following two questions:

1) If auto update statistics is on, would there ever be a reason why I might
want to run update statistics manually or via maintenance plan?

2) What condition triggers auto update statistics to run? If there are many
insert/update/delete to a table, would SQL know to update the statistics
promptly?

Thanks,
Jeff
From: Kalen Delaney on 28 Feb 2010 02:29
Hi Jeff

This article should answer your questions:

Statistics Used by the Query Optimizer in Microsoft SQL Server 2005
http://technet.microsoft.com/en-us/library/cc966419.aspx

--
HTH
Kalen
----------------------------------------
Kalen Delaney
SQL Server MVP
www.SQLServerInternals.com

"Jefft" <Jefft(a)discussions.microsoft.com> wrote in message
news:1486445F-1143-4E75-A4E8-B4764142229F(a)microsoft.com...
> I have the following two questions:
>
> 1) If auto update statistics is on, would there ever be a reason why I
> might
> want to run update statistics manually or via maintenance plan?
>
> 2) What condition triggers auto update statistics to run? If there are
> many
> insert/update/delete to a table, would SQL know to update the statistics
> promptly?
>
> Thanks,
> Jeff

 | 
Pages: 1
Prev: Sacramento, CA SQL Server group
Next: Repair SQL Corrupt database