Answer / Vardan Rastogi

"Transaction server isolation" in SQL Server refers to the level of consistency and isolation provided during a database transaction. There are several isolation levels available, such as READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE, each offering different trade-offs between performance and concurrency. Isolation levels determine when and how data changes made by one transaction can be seen by other transactions, helping to prevent conflicts and maintain data integrity.

what is meant by sql injection with example and one more question how to catch the errors in sqlserver

2 Answers  

---

Can we drop user if user mapped to any logins

1 Answers  

---

How to delete duplicate rows in sql server?

1 Answers  

---

explain the storage models of olap? : Sql server database administration

1 Answers  

---

what is the sql equivaent of the dataset relation object ?

1 Answers  

---

What is Peer to peer Replication?

1 Answers   CarrizalSoft Technologies, HCL,

---

How to define the name and server for a new dsn?

1 Answers  

---

What is default constraint?

1 Answers  

---

List out the differences between the clustered index and non-clustered index in sql server?

1 Answers  

---

can we have a nested transaction? : Sql server database administration

1 Answers  

---

What are the advantages of user defined function?

1 Answers  

---

Mention the 3 ways to get a count of the number of records in a table.

1 Answers  

---