Prev: Can't set up new user in Sql 2000
Next: Using LIKE..
From: Kalen Delaney on 3 Feb 2010 12:19
Somehow, this doesn't surprise me at all
:-)

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

"Tibor Karaszi" <tibor_please.no.email_karaszi(a)hotmail.nomail.com> wrote in
message news:u8hKxLKpKHA.1892(a)TK2MSFTNGP02.phx.gbl...
> We posted the reply same minute and pretty close the same information. :-)
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
>
> "Kalen Delaney" <please_reply_on_newsgroups(a)domain.com> wrote in message
> news:5FA1FAB4-BC24-47A6-81FB-A729576B3365(a)microsoft.com...
>> dbcc updateusage does not update the distribution statistics, but rather
>> the row and page count information. To update distributions statistics,
>> run UPDATE STATISTICS.
>>
>> --
>> HTH
>> Kalen
>> ----------------------------------------
>> Kalen Delaney
>> SQL Server MVP
>> www.SQLServerInternals.com
>>
>> "RG" <nobody(a)nowhere.com> wrote in message
>> news:10D6EDAA-DB6E-452B-BD08-966328F5F384(a)microsoft.com...
>>> I ran dbcc updateusage ('demodb').
>>>
>>> I than ran dbcc show_statistics ('location', 'ix_phone'). The update
>>> date (statistics update date) remained old. Why? Why weren't
>>> statistics updated?
>>>
>>> BTW.. I have auto update statistics set to on.
>>>
>>> Thanks in advance
>>
First  |  Prev  | 
Pages: 1 2
Prev: Can't set up new user in Sql 2000
Next: Using LIKE..