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.

Answer / anil sharma

Serialization means organise data with relations between
tables.Removing duplicate row maintain structured data.

Answer / nixo

Serialization, This is the higest level of Isolation.
When this is on, no dirty reads, no nonrepeatable reads
and no phantom rows.

What are the advantages of using cte?

0 Answers  

---

How many databases Microsoft SQL server provides?

0 Answers   Abacus,

---

How many types of keys are there?

0 Answers  

---

How do you know if sql server is running on your local system?

0 Answers  

---

Can we add our custom code in ssis?

0 Answers  

---

---

What is temporal data type?

0 Answers  

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

---

What stored by the model? : sql server database administration

0 Answers  

---

explain different types of jions with examples briefly?

3 Answers   Zensar,

---

one table has four field id,name,design,salary. i have to find maximum salary .

6 Answers  

---

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

---