Anyone please explain me the concept of Serialization?

Answer Posted / monal

Serialization is highest level of Isolation. Most resource
intensive and slowest isolation level. But because of
serialization isolation level all concurrency issues like
dirty read, repeatable read and phantom read won't occur.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2057


What are the new security features added in sql server 2012? : sql server security

711


Where are full-text indexes stored?

743


Where are sql server user names and passwords stored in sql server?

751


What is BCP? When does it used in sql server 2012?

779


How to create a dynamic cursor with the dynamic option?

735


What is tablix?

136


How can I track the changes or identify the latest insert-update-delete from a table?

729


What is indexing in sql server with example?

716


What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks

1819


Explain the working of sql privileges?

819


In case you have filters in your report, when filters will be applied in cached report instance?

91


How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

779


What is a with(nolock)?

766


What are the difference between clustered and a non-clustered index?

773