Answer / Najim Ali

Auto commit in SQL Server refers to the default behavior where each statement executed within a connection automatically commits after it completes, unless an explicit transaction has been started. This can be disabled using the SET IMPLICIT_TRANSACTIONS OFF command.

Can you force a query to use a specific index?

1 Answers  

---

Distinguish between commit and rollback?

1 Answers  

---

application server is slow what may be the problem

1 Answers   Microsoft,

---

Is SET a SQL Keyword?

4 Answers   BitWise,

---

mention different types of relationships in the dbms?

1 Answers  

---

What is multilevel indexing?

1 Answers  

---

What is a function? Give some example?

3 Answers  

---

Why functions are used in sql server?

1 Answers  

---

What is difference between delete & truncate commands?

1 Answers  

---

What are the types of joins in sql?

1 Answers  

---

What is subquery in sql?

1 Answers  

---

Explain partitioned view?

1 Answers  

---