Because cursors indicate a row-by-row (if this row contains ... then I'm not interested) logic whilst sql server is optimized for set-based logic (give me all that have the value...

Odd error.

What happens if you run the select at line 53?

DECLARE @dbname sysname

SET @dbname=NULL

select name, suser_sname(sid), convert(nvarchar(11), crdate),

dbid, cmptlevel from master.dbo.sysdatabases

where (@dbname is null or name = @dbname)

Which...

Try to have the application/situation run at a machine for monitoring its performance against a known setup.

http://www.sql-server-performance.com/gv_baselining_tips.asp.

also check this out:

http://www.sql-server-performance.com/sql_server_performance_audit3.asp

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...