Does the snapshot isolation level transaction wait for other transactions to complete before it can start working on its own?
If we have ongoing unfinished transactions with any isolation level, does a new transaction with snapshot isolation level wait for their completion before it starts taking a snapshot?