sql2005

1

Patch to latest service pack ( for example SQL2005 SP3 ) .

升级到最新服务包（例如SQL2005SP3）。
2

This can be desirable if you think SQL2005 is promoting transactions too often , but the preferred method is TransactionScope .

如果您觉得SQL2005提升事务级别过于频繁，不妨试试这个做法。不过，最佳选择则是使用TransactionScope。
3

SQL2005 has snapshot-based isolation levels that prevent readers from blocking writers or writers from blocking readers without allowing dirty reads .

SQL2005有一个基于快照的隔离级别，它能在不允许“脏读”的情况下避免数据读取阻塞数据写入，或者数据写入阻塞数据读取。