What is data compression?

1068

---

How to copy the tables, schema and views from one sql server to another?

1112

---

what is unique and xaml nonclustered index

1104

---

Is it possible to create trigger on views?

1036

---

What is user-defined inline table-valued function?

1008

---

Difference between uniqe index and uniqe constraint?

1050

---

What are ddl triggers and types of ddl trigger?

1104

---

How many non clustered indexes there can be on table ?

964

---

What are different types of subquery?

1314

---

Explain few of the new features of sql server 2008 management studio

982

---

What are “lost updates”?

1045

---

What command do we use to rename a db, a table and a column?

986

---

What is the difference between a function and a trigger?

1129

---

What is t-sql script to take database offline – take database online.

1144

---

What is a filestream?

1052

---