I'm happy to provide this info, but my first query was really about partitioning, and if there are any known issues i.e. "some queries can run slower after partitioning unless...

what's the best way to provide this info?

ok, just found the answer:

Provider=SQLNCLI

Actually, its simply running the following that breaks bcp:

CREATE

 PROCEDURE [dbo].[MISR020_SELECT_AC]

AS

declare

@MinFCPT smallint

select...

Is it possible to monitor the IO against individual datafiles?

my guess is that the optimiser cannot get accurate distribution statistics for the firstname column when a "like" is used.

use "DBCC SHOW_STATISTICS ( table , target )" to look at...

upgrade to 2005 where you can rebuild an index on-line, otherwise, I don't think you have any choice.

Hi All

Thanks for your responses. Very useful

Andy

the table occupies 4 pages. Is it coincidence that scan density is being reported as 25%? Did your table fit into 2 pages and report 50%?

Andy

Do you know a way of automatically running a script before SQL is stopped i.e. a pre-sql shutdown script?

Any ideas why this may have happened in the first place?

Thanks Greg

Can you get back to your previous design? If so, run the overnight stuff against this. Is it fast? If so, get some execution plans and compare to the new...

just what I wanted! Thankyou very much

Andy

I have a script to do this. If you don't have any luck finding elsewhere, I can e-mail it to you. Let me know

Andy

andy.cudlip@scottish-southern.co.uk