What is difference between commit and rollback when used in transactions?

1025

---

Data table as parameter in sql server?

1111

---

What is the xml datatype?

1127

---

What is the difference between index seek vs. Index scan?

1066

---

What is set nocount on and what is set nocount off?

1002

---

Explain intellisense for query editing

1080

---

Explain primary key and foreign key constraints?

1099

---

Explain following error properties?

1068

---

Explain system scalar functions?

1050

---

How to find index size for each index on table?

1060

---

What is database mirroring?

1178

---

What are dml triggers and types of dml triggers?

1039

---

What is difference between line feed ( ) and carriage return ( )?

952

---

What languages bi uses to achieve the goal?

1058

---

What is checkpoint process in the sql server?

1077

---