sqlserver降低锁级别,能减少死锁的可能性(当然,数据安全性会稍稍降低?)

2/13/2017来源:SQL技巧人气:4783

ALTER DATABASE mbt SET SINGLE_USER WITH ROLLBACK IMMEDIATE ; 

ALTER DATABASE mbt SET READ_COMMITTED_SNAPSHOT ON; 

ALTER DATABASE mbt SET MULTI_USER;