What are points to remember while using the fillfactor argument?

1019

---

What is oltp (online transaction processing)?

1061

---

Which tcp/ip port does the sql server run on? How can it be changed?

1120

---

What are different types of views?

990

---

What are the advantages of policy management?

1047

---

what is nonclustered index

1006

---

Explain system views?

1133

---

What are various limitations of the views?

1096

---

How to insert stored procedure result into temporary table?

1068

---

What does top operator do?

1081

---

What is self contained scalar sub query?

1021

---

How can I get data from a database on another server?

1053

---

Find nth lowest salary or get nth lowest salary?

1088

---

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1082

---

What is instead of dml trigger?

1059

---