how long does it take to finish approximately?

No the sort in tempdb option is off

you mean by this script I find the blocked spid and kill it manually?

SELECT p.spid,

...

MyDoggieJessie (3/15/2014)

---

What do you mean the entire database is locked? The locks should just be on the table itself (unless you are clicking around in SSMS, then...

thanks Yes...

GilaMonster (11/24/2013)

---

If an insert explicitly specifies a value for a column that has a default, then the explicitly specified value will be inserted not the default.

If you're replacing a default...

Why should it ignore the default?You mean again it inserts a random data not bigger one?

My table just has 2 fields : id that is uniqueidentifier and a nvarchar() it...

I am so sorry ,I mean High Protection,with safety FULL, but has no witness server .

I know that with set partner off I remove mirroring,but when I run SET...

The mode is High Performance,but I configure mirroring on my local for test not main server.Is it because of low resources?

Thanks a lot Gail

Another question,if the principal fails,the way for manual failover is

USE master

go

ALTER DATABASE mirrordb SET PARTNER OFF

GO

RESTORE DATABASE mirrordb WITH RECOVERY

GO

and it will bring the mirror online?

and...

so if I have latency(I can see unsent log when inserting a 10000000 records loop in Launch Database Mirroring Monitor)how can I prevent data loss?Is there any solution?

This is the...

and we can decrease the time for waiting with :

ALTER DATABASE dbname SET PARTNER TIMEOUT 20 ?

This problem is for most of the query that is because of parameter sniffing,so some times in app it uses the correct plan as the same in SSMS,and some times...

Thanks Jason

My query is a simple select statement via sp_executesql but linq does not suport option(optimize for unknown) or OPTION(RECOMPILE).

Is it possible that the plan in cache suddenly removed because...

I have 2 database.One of them is an archive DB and it is read only.The main db has insert ,update and select statement on it, and also an update statistics...

Thanks a lot

Yes according to your comments I try to create clustered index but I can not use with schema binding cross database 🙁

Thanks Gail for your help 🙂