Hello friends, Sometimes we get the data that needs to be unique but can also get NULL records. Existing ways to achieve uniqueness doesn’t allow NULLs (Primary Key) or allow max one NULL (Unique Constraint). Let’s take an example to understand this better. Suppose, you have an Employee table with fields like Id, FirstName, MiddleName,… Continue reading Store Multiple NULL values with unique data in SQL Server
Category: SQL Server/SSIS/SSRS
Row Versioning Based Isolation Levels in SQL Server
Hello guys, Row Versioning based Isolation levels are very useful in reducing blocking. Which are. Read Committed (default) Isolation level with READ_COMMITTED_SNAPSHOT database option is ON. Snapshot Isolation level with the ALLOW_SNAPSHOT_ISOLATION database option is ON. Read committed isolation using row versioning provides statement-level read consistency however Snapshot isolation provides transaction-level read consistency. Statement-level read… Continue reading Row Versioning Based Isolation Levels in SQL Server