How to find the list of fixed hard drive and free space on server?

1193

---

What is difference in performance between insert top (n) into table and using top with insert?

1040

---

What is change data capture (cdc) in sql server 2008?

1024

---

Where are sql server usernames and passwords stored in the sql server?

1112

---

Explain left outer join and right outer join?

1034

---

What is the bookmark lookup and rid lookup?

996

---

What is local temp table?

950

---

What is difference between getdate and sysdatetime in sql server 2008?

1047

---

Explain insert into select statement?

953

---

What are policy management terms?

981

---

What is data compression?

989

---

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

1047

---

what is unique and xaml nonclustered index

1044

---

Is it possible to create trigger on views?

970

---

What is user-defined inline table-valued function?

943

---