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

1019

---

Data table as parameter in sql server?

1107

---

What is the xml datatype?

1125

---

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

1066

---

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

996

---

Explain intellisense for query editing

1076

---

Explain primary key and foreign key constraints?

1093

---

Explain following error properties?

1066

---

Explain system scalar functions?

1046

---

How to find index size for each index on table?

1056

---

What is database mirroring?

1176

---

What are dml triggers and types of dml triggers?

1031

---

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

951

---

What languages bi uses to achieve the goal?

1052

---

What is checkpoint process in the sql server?

1074

---