Thanks Gianluca for your reply,

Name was correct.

Here is what we did next, after all troubleshooting and sql client re-installation on application server, it still did not connect properly. the behaviour...

Hi,

You can not see difference with few rows as it will be adjusted with same page.

Try inserting 1 million rows and then compare.

If you do not find the difference, truncate...

here is an article that has command also.

http://sql-articles.com/articles/high-availability/how-can-i-bring-mirror-database-online-after-principal-server-is-down/

time out expired.. which one? connection timeout or command timeout? And yes, did you try the query from management studio as suggested by John Mitchell?

I guess Hyper Treading is enabled on your server. Microsoft recommends to set maxdop=number of physical processors when HT is enabled. However they also recommend to monitor and test it...

please check the connection property in trace for the client application. what is isolation level set there.

what isolation level are you using when running from QA. If application uses read...

Hi,

you can try this.

select a.Uniq_ID, a.DocCode, a.EffectiveDate,

b.Uniq_ID, b.CodeStatus, b.InsertedDate

from #temp_main as a

left join #temp_status as b on b.Uniq_ID = a.Uniq_ID

inner join (select uniq_id, min(InsertedDate) as InsertedDate from #temp_status...

Hi Krasavita,

I could not find any method to directly restore on another server through query. Probably you can use osql command utility from inside the job to get it done....

and assume what if no row qualified?

Yes, only else part will execute as the condition is not true. What is confusion? do you think 0=1 is correct?

select isnull((select 1 where 1=2 ),1)

becuase it is searching for a not null value. no row returned is being treated as null that sounds reasonable.

can you check the result of below query? this will answer...

hi,

I belive there is error within transaction and transaction is not committed. can you add error handling within the transaction to check if there is any.

Alternately, add test line...

I assume you mean diffferent drive instead of different path. Further I assume, the drives come from different physical disk / LUNS.

Yes it will improve even for simple recovery. The...

Hi,

Index A is indeed in use as Gila suggested earlier.

Index B not being used for query, but it may be important if it is clustered index or Primary Key.

I...