Have you already tried the solution referred in this Microsoft article;

http://support.microsoft.com/kb/930284

Have you already tried the solution referred in this Microsoft article;

http://support.microsoft.com/kb/930284

I agree that the code might not be that efficient but this query was working for more thn 2 yrs and just before a month it went bad.it spiked to...

I have attahced the execution plan in doc format as for some reason save execution plan is disabled in my server and ald there is no table D ...it was...

thats true....backups are always the lfe savers!!!!..we still have old backup procedure inplace ..

Here is what i did

1)Create a new user defined database role

2) Select the schema to which all stored procedure belongs(1 or more) from owned schema selections

3) add the member...

The overhead depends on the amount of load that your server has

As per the articel on microsoft

High-performance mode, runs asynchronously. The mirror server attempts to keep up with the log...

High Safety supports synchronous operation means that your principal and mirror databases are always in sync state wilt almost no data loss

High performance supports async operation so both databases are...

We faced the same issue of losing the tempdb files once and this is what we did....

We had cloned the existing production server but did not clone the drive containing...

As per my understanding I think what you did was filling the space on the operating system's drive but the log file still might have some empty space in it.So...