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 is purpose of normalization?

0 Answers  

---

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

What is index fragmentation in ms sql server?

0 Answers  

---

What is difference between getdate and sysdatetime in sql server 2008?

0 Answers  

---

---

Consider the table T1 it consits A,2,3,4 consider another table t2 it contain 1,2a,3a,4a now i need o get the upadted answer

3 Answers  

---

What is the difference between a "where" clause and a "having" clause?

0 Answers  

---

How data can be copied from one table to another table?

0 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,

---

how to get max salary with employee number by using one select query and max function ??

3 Answers   Genpact,

---

How many partitions a clustered index has by default in sql server 2012?

0 Answers  

---