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
Explain what is “asynchronous” communication in sql server service broker?
What is parameterized reports in ssrs ?
Which are the new data types introduced in sql server 2008?
What is sleeping status in sql server?
What is hot add cpu in sql server 2008?
Can a table be moved to different filegroup?
Do you know the capabilities of cursors?
Explain the etl (extraction, transformation, and loading)?
Explain how would you store your query in an SSRS report or a Database server?
What is checkpoint in sql server?
Why and when do stored procedure recompile?
How to locate and take substrings with charindex() and substring() functions?
Which tcp/ip port does sql server run on? How can it be changed?
What is transaction server explicit transaction?
What is the process of indexing?