thanks Greg, but in our situation I am being led to believe its a little more complicated than that.

The SQL Server 2000 and 2005 instance is on a server in...

Hi Michael

thanks for your reply - this bears out some testing I did yesterday.

I could get the restore done with norecovery and the status of the db would be 'recovering',...

OK a differnt situation but this is along the same lines.

I will be getting log shipped transaction logs from a production server (I have not say in this) into a...

Hi Mark

from previous experience when I get the HY000 error its telling me it cannot extend the ttansaction log any further. However on one of the sites I look after...

thanks for the input all.

at this stage I'm not sure that the client will wait till 2008, but its something I had to explore.

What is the typical time frame for...

Michael - thanks for your reply. I have read the articles you have suggested. Looks like even mirroring can be complicated.

I was originally looking for a way to preserve the...

I am currently looking at this myself for a proposal paper for a client's client.

If I understand you correctly - your client is using mirroring to replicate to a second...

Thanks Jeff

when I said table variable I meant when its a small table. In my other job - we use table variable when we need a small table to help...

thanks very much for all the input - appreciate it all.

You have give me much more to think about.

Now just have to try and figure out the best way forward.

regards

Hi Jeff,

no not this piece of the code, but another sample I ran a qep for has a 9.1 million row table as an input into a select which the...

thanks for your reply.

Based on what has been indicated in this thread I'd already identified those areas as recompile causes. Was hoping that you might spot something else that was...

OK - here's the code - one part of many, but this code I did notice blocking itself.

(Apologies if this is not how I should do it - just...

apologies again. I have started to go through the links and have some more questions.

All this started because I put new indices and new statistics on columns recommended by the...

Another question:

if a stored proc is being executed and its then recompiled before it finishes what happens to the thread that is in the middle of the execution - does...

thanks for the replies.

Its the division of labour thing I guess. That's why I prefer to have the sysadm and dba all in the one person. We're dealing with third...