Re: Advice Please


"Ant Zucaro" <azucaro@xxxxxxxxx> wrote in message
news:1157480123.878523.147590@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Also, are you running frequent update stats and DBCCs? Both are
critical to maintaining/analyzing performance.

-Ant


(SNIP)

DBCC doesn't exist with ASA - it's dbvalid. (I'm not sure as to which
version it became available with.) Nor does "update statistics" but
basically the optimizer continually does it in memory as I remember.


.

Relevant Pages

  • Re: Advice Please
    ... (SNIP) ... DBCC doesn't exist with ASA - it's dbvalid. ...
    (comp.databases.sybase)
  • Re: Table problem ?
    ... > UPDATE STATISTICS ... >>I have one table which name is medicalhistory which structure is as ... >> DBCC results for 'medicalhistory'. ... If DBCC printed error messages, ...
    (microsoft.public.sqlserver.clients)
  • Re: Table problem ?
    ... UPDATE STATISTICS ... >I have one table which name is medicalhistory which structure is as ... > DBCC results for 'medicalhistory'. ... If DBCC printed error messages, ...
    (microsoft.public.sqlserver.clients)
  • Re: Does DBREINDEX update stats?
    ... > (Assuming SQL Server 2000, auto create statistics on, auto update ... > UPDATE STATISTICS WITH FULLSCAN ... > Is there any need to run UPDATE STATISTICS after DBCC DBREINDEX? ... are asking this question in an Oracle news group. ...
    (comp.databases.oracle.misc)
  • Update statistics and dbcc dbreindex
    ... Is it possible to have a Update Statistics with fullscan slower than a dbcc ... dbreindex on the same table? ...
    (microsoft.public.sqlserver.server)
Loading