The row thing is only relevant for tables (and indexes, depending on how you look at it). Not
statistics. So, don't worry about it.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
> Thanks Tibor,
> I readed about statistics, but the thing that let me perplexed and scares to
> me are the 0 rows in the mmc console
> Nothing to know or do about them?
> > These are not indexes. It is auto-generated statistics. A good thing.
> > To read more, see CREATE STATISTICS and DROP STATISTICS.
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sql...
> > > Hi workers,
> > > I have some dbs in wich I find a lot of _wa_sys* indexes and 0 zero rows
> in
> > > the mmc console
> > > I turned off the auto-create-statistics that done this sysindexes but it
> > > don't delete them.
> > > The bad thing that I see are these zero rows, even if data are inside.
> > > I done the dbcc updateusage without result.
> > > Can it give me some problems?
> > > a lot of thanks for your answers
> > > ____________________________
> > > Massimo Camplone
> > > Italy IT Senior Consultant
> > > ICQ UIN at 11871749
> > > ____________________________
by