Well yes looping over each id and creating xml for them will be the same thing.

How about you have 3-4 select statements and which generates 3-4 xmls like this :-

...

This is a indirect cursor. For every row which needs to be updated you are executing the subqueries to find the XML.

Instead Join your temp table with respective tables and...

Sql server on its own balances load by assigning threads to processor with least runnable threads.

Unless you have some processor affinity set on your server.

This happened to me when i installed some Stand alone visual studio for C# scripting.

Alright, i have never worked with Cubes in 2000 Analysis services but have worked with 2005.

My plan of action would be :-

Check the data in the tables, there should be...

yes create a linked server.

By creating memory pressure, i meant that the stack dump mentions the memory used at the time of dump, so by runnign extraneous queries of big-joins etc .. you can...

I am writing generic script :-

select (case

when not ft.col1 is null then 2

...

As far as i know, you have to take full backup of Master database and cannot do filegroup backup for it.

If you have full backup of master database then you...

Well I would presume that one has to remove the mirror, restore the database and re-establish the mirror.

I have never done it before.

Let us know how you do it...

1. Run Sql profiler and look out for high reads.

2. Execute Sp_who2 active and look for highest IO value with lastBatchtime timestamp old enough to suggest that it was running...

My theory is that the Sql server was reeling under memory pressure at the time when this openquery statement was executed. The query fetched data and didnt have any memory...

Sounds reasonable and should work. Never tried it though :). Try on dev server first.

Well the network card thingi was good to know.

Now you have 2 problems

1. Lotsa key locks

2. High Disk Reads

If your processes are acquiring locks and keeping them for long...

My thoughts and plan of action:-

1. First lets not call it Deadlock.

2. As GilaMonster said run the trace flag.

3. Run your business object report and at the same time run...