Answer / Satish Kumar Gupta

Commit and Rollback are SQL Server commands used to manage database transactions. Commit confirms all changes made within a transaction, making them permanent.nnRollback undoes all changes made within a transaction, effectively canceling it and returning the database to its state before the transaction began.

Which system table contains information on constraints on all the tables created?

2 Answers  

---

Does partitioning improve performance?

1 Answers  

---

How to create a stored procedure with a statement block in ms sql server?

1 Answers  

---

What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

What is a performance monitor?

1 Answers  

---

Difference between Function and Stored Procedure?

9 Answers   C1 India, NA,

---

What is difference between equi join and inner join?

1 Answers  

---

what is difference between nchar and char in Sql server ?

3 Answers  

---

What happens if null values are involved in datetime operations?

1 Answers  

---

Can we create SP inside SP ? If no Y ? If yes Y ? Explain with an example ?

3 Answers   IBM, L&T,

---

List out some of the requirements to set up a sql server failover cluster?

1 Answers  

---

Why and when do stored procedure recompile?

0 Answers  

---