Azure SQL Database – The Default Isolation Is?

So what is the default isolation level for Azure SQL Database? I ran the following code to check it out.

Continue reading

Advertisements

SQL Server Phantom Reads

With Halloween around the corner what better topic to discuss than phantom reads. A phantom read occurs when rows have been inserted after a read operation and becomes visible in a follow-up read operation within the same transaction.

Continue reading