nobody?

Also a great change from SP3 to SP4 is that the datatypes have to match in order to use an index.

*found the link

http://support.microsoft.com/default.aspx/kb/899976

Haven't used analysis yet. Have you rebooted the machine(s)?

I can be because of parallel processing/fetching.

Have you also downloaded the analysis service pack 4? It comes in a separate package.

see

SQL2000.AS-KB884525-SP4-x86-ENU.EXE (analysis service pack)

and

SQL2000-KB884525-SP4-x86-ENU.EXE (sql server service pack)

at

http://www.microsoft.com/downloads/details.aspx?familyid=8E2DFC8D-C20E-4446-99A9-B7F0213F8BC5&displaylang=en

Have you tried starting sql server from the command line

with the

-dmaster_data_file_path

-lmaster_log_file_path

-eerror_log_path

parameters ?

example :

sqlserver.exe -dC:\MyNewDBLocation\master.mdf -lC:\MyNewLogLocation\master.ldf -eC:\MyNewErrorLocation\ERRORLOG

Since L & E seems to be unavailable (see event viewer)

Part 1: inserting in a new table

Insert into newtable

(Application)

select ApplicationX from tableY

where ApplicationX is not null /*blank checking

and application1''

and not exists

(select * from newtable where application=ApplicationX ) /*dupe checking*/

repeat...

Have you checked the event logs?

off topic change

FROM vw_Referrals_Grouped

to FROM dbo.vw_Referrals_Grouped vw_Referrals_Grouped

to prevent recompiles

Having the IIS seperated will indeed lessen the contention.

Is there another candidated for the clustered index? Datetime and 10 ints seems to be large. Exchanging for a non-clustered index?

Any possibility...

Also try to match the datatypes for index usage. If active_flag is a bit-field use active_flag = convert(bit,1)

You could try to replace the not in   to not exists . With in it has to fetch all records before comparing, with exists it can cease fetching if one...

Most likely splitted. Why sql server would move 10gb tables as a whole because the mdf suddenly got full.

Perhaps you could pass the subheader as a parameter as well.

Is this like

Questionnaire

Header

Header_level2

Header_level3...

?

a wild guess, do both tables have a primary key or unique index?