Anyone please explain me the concept of Serialization?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anil sharma
Serialization means organise data with relations between
tables.Removing duplicate row maintain structured data.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nixo
Serialization, This is the higest level of Isolation.
When this is on, no dirty reads, no nonrepeatable reads
and no phantom rows.
Is This Answer Correct ? | 0 Yes | 0 No |
Explain system scalar functions?
Can a synonym name of a table be used instead of a table name in a select statement?
Can we create nonclustered index in a table without creating a clustered index
What is dknf in normalization form?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
what is the disadvantage of SQL Loder?
How to view the error log for any specific instance? : sql server database administration
what are different types of backups available in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What are secondary xml indexes?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is log cache in sql server?
How to download microsoft sql server 2005 express edition?