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 |
Why I can not enter 0.001 second in date and time literals in ms sql server?
What is the native system stored procedure to execute a command against all databases?
How will you fine tune a stored procedure or what are the steps that should be taken to fine tune or optimize a stored procedure?
can an automatic recovery be initiated by a user? : Sql server administration
how many instance use in sql server 2005
What does ss stand for sexually?
Define left outer join?
Does any body please help me what question's have asked for SSRS in the interview?
What is difference between index seek vs. Index scan?
What are the main sources of data?
What is msdb database? : SQL Server Architecture
What is merge statement?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)