Given the situation where we had to put a hot fix asap... This worked brilliantly. We have now time to fine tune the code.

I will now try using the recompile...

Hi I have modified the query as directed. The filters in the query are on the columns that are part of the clustered index (primary key) so I am not...

There is only one index - clustered index. The primary key is made of 3 colums FixingSource, FixTime, InstrumentID.

<deadlock>

<victim-list>

<victimProcess id="process4c430c8" />

</victim-list>

<process-list>

<process id="process4c430c8" taskpriority="0" logused="348" waitresource="PAGE: 8:1:1502781 " waittime="147" ownerId="31042786" transactionname="user_transaction" lasttranstarted="2014-07-03T17:01:32.197" XDES="0x377a856a8" lockMode="S" schedulerid="18"...

Could you stop posting such messy questions that confuse people

Hi Renuka,

I believe when the mirror is down in a database mirroring session which is in synchronous mode, the users will not receive a confirmation of a commit or roll...