Answer Posted / a

int

what is the difference between Tabular and Matrix report?

124

---

What is the filtered index?

559

---

What is BCNF? How is it better than 2NF & 3NF?

597

---

What the difference between UNION and UNIONALL?

570

---

Is sql server a database?

531

---

---

Can a database be shrunk to 0 bytes, if not, why?

642

---

What are “lock” hints?

587

---

What are the different types of locks in the database?

486

---

Define the one-to-one relationship while designing tables.

509

---

What is instead of trigger sql server?

495

---

What are a database and a data warehouse?

566

---

What are .mdf files?

518

---

What is the difference between varchar and nvarchar?

520

---

What is the purpose of sql profiler in sql server?

509

---

How many types of keys are there?

526

---