Re: 2 Billion records a table

Thanks for the reply.
Major problem is when you do select * from that table, you can not query out
( even generate estimate execute plan ), the process hang on there.

--
David Liu
Sr. DBA
MCSE/MCDBA
Moneris Solutions



"Myles.Matheson@xxxxxxxxx" wrote:

> Hello David,
>
> Have you tried doing a straight row count?
>
> I think the sp_spaceused uses the table statistics to return row
> counts.
>
> SQL server may not have updated the table statistics after operation
> was completed. This is a common problem with large tables.
>
>
>
>
> Hope this Helps
>
> Myles Matheson
> Data Warehouse Architect
>
>
.

Loading