snapshot-isolation
With TSQL SNAPSHOT ISOLATION, is it possible to update only non-locked rows?
A large SQL Server 2008 table is normally being updated in (relatively) small chunks using a SNAPSHOT ISOLATION transaction. Snapshot works very well for those updates since the chunks never overlap.[详细]
2023-03-25 07:03 分类:问答Hardware based "snapshot" functionality, like on VMWare
The way we are currently working when developing out software involves developing inside a vmware virtual machine running visual studio on windows xp. This is mainly due to the fact that our software[详细]
2023-02-13 22:13 分类:问答Snapshot transaction Isolation levels: it really works as advertised?
Have you any problems using it on high concurrency environment? It\'s really works as advertised by M开发者_运维技巧S? I\'m using SQL Server 2005 and would like to hear the experiences of those who ar[详细]
2022-12-21 21:44 分类:问答SQL Server 2005 becomes blocked with no locked or locking processes
We have a database (let\'s call it database A) which becomes unusable every some days and we have to restart it. When I say unusable means all applications using it just block there waiting for the da[详细]
2022-12-14 23:02 分类:问答