I’m trying to study for the next MS SQL Server 2005 exam and keep getting annoyed by practice questions that are wrong. The latest one to bother me was this statement in one of the answers:
“Both read committed snapshot isolation and snapshot isolation can produce phantom records.”
Wikipedia has a nice definition of the problem of [...]
Following on from yesterdays post on sys.dm_tran_active_snapshot_database_transactions here is a look at four more dynamic management views that contain information about snapshot transactions.
sys.dm_tran_current_snapshot displays the transaction sequence number (XSN) for each transaction that was active when the current snapshot transaction started. sys.dm_tran_transactions_snapshot displays the all of the transactions with a XSN that were active when [...]
I’ve worked out its impossible to just memorise all of the new Dynamic Management View and Functions in SQL Server 2005; so my new approach is to actually use one or two and see what they do.
According to the documentation for sys.dm_tran_active_snapshot_database_transactions it returns “a virtual table for all active transactions that generate or potentially [...]