What is data compression?

1066

---

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

1107

---

what is unique and xaml nonclustered index

1102

---

Is it possible to create trigger on views?

1033

---

What is user-defined inline table-valued function?

1005

---

Difference between uniqe index and uniqe constraint?

1046

---

What are ddl triggers and types of ddl trigger?

1097

---

How many non clustered indexes there can be on table ?

963

---

What are different types of subquery?

1311

---

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

980

---

What are “lost updates”?

1045

---

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

983

---

What is the difference between a function and a trigger?

1125

---

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

1139

---

What is a filestream?

1049

---