dbcc show_statistics wrong output

Has anyone ever come across the rows column in dbcc show_statistics not
reporting the right number of rows( I mean way off : Actual count maybe 500
whereas the rows column indicates 50000 ) even after stats are being updated
? Could that be a bug ? Using SQL 2K and SP2 with Slammer HF ofcourseThey may well not be accurate. You need to run DBCC UPDATEUSAGE or UPDATE
STATISTICS WITH FULLSCAN to get them right. See BOL for details
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uaO6TeduDHA.560@.TK2MSFTNGP11.phx.gbl...
Has anyone ever come across the rows column in dbcc show_statistics not
reporting the right number of rows( I mean way off : Actual count maybe 500
whereas the rows column indicates 50000 ) even after stats are being updated
? Could that be a bug ? Using SQL 2K and SP2 with Slammer HF ofcourse

DBCC SHOW_STATISTICS

I would like detail information that goes along with DBCC SHOW_STATISTICS
within SQL Server 2000. I am trying compare indexes within a table to see
which indexes were used the most.
Thanks,DBCC SHOW_STATISTICS will not give you any information about how much
indexes are used or even if they are used at all. There is no really good
way in 2000 to do that but 2005 does add some features along those lines.
But to answer your question about the details look in BooksOnLine and here.
http://www.microsoft.com/technet/pr...5/qrystats.mspx
Even though this is for 2005 it has some really great info and a lot still
applies to 2000.
Andrew J. Kelly SQL MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:BB5E2F12-D312-4CF4-AD7C-AC364CAF6C43@.microsoft.com...
> I would like detail information that goes along with DBCC SHOW_STATISTICS
> within SQL Server 2000. I am trying compare indexes within a table to see
> which indexes were used the most.
> Thanks,

DBCC SHOW_STATISTICS

I would like detail information that goes along with DBCC SHOW_STATISTICS
within SQL Server 2000. I am trying compare indexes within a table to see
which indexes were used the most.
Thanks,
DBCC SHOW_STATISTICS will not give you any information about how much
indexes are used or even if they are used at all. There is no really good
way in 2000 to do that but 2005 does add some features along those lines.
But to answer your question about the details look in BooksOnLine and here.
http://www.microsoft.com/technet/pro.../qrystats.mspx
Even though this is for 2005 it has some really great info and a lot still
applies to 2000.
Andrew J. Kelly SQL MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:BB5E2F12-D312-4CF4-AD7C-AC364CAF6C43@.microsoft.com...
> I would like detail information that goes along with DBCC SHOW_STATISTICS
> within SQL Server 2000. I am trying compare indexes within a table to see
> which indexes were used the most.
> Thanks,

DBCC SHOW_STATISTICS

I would like detail information that goes along with DBCC SHOW_STATISTICS
within SQL Server 2000. I am trying compare indexes within a table to see
which indexes were used the most.
Thanks,DBCC SHOW_STATISTICS will not give you any information about how much
indexes are used or even if they are used at all. There is no really good
way in 2000 to do that but 2005 does add some features along those lines.
But to answer your question about the details look in BooksOnLine and here.
http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
Even though this is for 2005 it has some really great info and a lot still
applies to 2000.
--
Andrew J. Kelly SQL MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:BB5E2F12-D312-4CF4-AD7C-AC364CAF6C43@.microsoft.com...
> I would like detail information that goes along with DBCC SHOW_STATISTICS
> within SQL Server 2000. I am trying compare indexes within a table to see
> which indexes were used the most.
> Thanks,|||On Fri, 11 Nov 2005 18:28:39 -0500, "Andrew J. Kelly"
<sqlmvpnooospam@.shadhawk.com> wrote:
>DBCC SHOW_STATISTICS will not give you any information about how much
>indexes are used or even if they are used at all. There is no really good
>way in 2000 to do that but 2005 does add some features along those lines.
>But to answer your question about the details look in BooksOnLine and here.
>http://www.microsoft.com/technet/prodtechnol/sql/2005/qrystats.mspx
>Even though this is for 2005 it has some really great info and a lot still
>applies to 2000.
Good stuff!
And this Yukon/2005 thing may just be hot!
.. as Paris Hilton would say ...
J.sql