I know Elapsed time may depend on ... many things, but should I think CPU time is not

an accurate and steady data?

Many performance tests I make are based

on...

Thanks Antares686, I know I should add an index on this column, but it was just a test to compare to what Andyj93 said:

"I ran a test on a simple...

How can you have so good response time?

When I run a Select count(*) on a 7 million rows table with a where clause on a datetime column (no index on...

It should be OK now. It was "just" a little bug: you can see the description at this address: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q308126.

I got a FIX for this problem and I'll...

OK I've already made all that (re-create index, dbcc update_usage ...) but I would like to have nothing to do !!! since auto-update is ON.

It's SQL Server 7 SP 3 .Perhaps I'd not been very plain: the "rows" column is updated but with a bad number of rows. Very strange.

I've been looking at the Microsoft KB too but found nothing that sounds like my problem.Thanks for your contribution.

I' ll tell you about the continuation.

I'm almost sure that index has not been created with STATISTICS_NORECOMPUTE option.

How can I be absolutely sure. When I execute sp_autostats on this table, flags for all indexes are ON.

...

Auto stats is ON. Other indexes (non cluster) are correct. It seems to be a problem when we run a query on this table that could use the clusterred index....

Thanks's Neil.

I think DTS is not as fast as FTP + BCP;

so whe had a preference for FTP, but it seems not easy!

Alain RIBIERE

OPAC PARIS FRANCE

quote:

---

If you use DTS you can shape (transform) the data. When the dts package runs it can then clean any hidden...