How you can move data or databases between servers and databases in sql server?

1048

---

What is a fill factor?

1080

---

How can you find out which stored procedures are recompiling?

916

---

What is a transaction and why is it important?

1085

---

Explain a differential backup?

1003

---

between cast and convert which function would you prefer and why?

952

---

What are the advantages dts has over bcp?

1000

---

What does it mean if @@cursor_row returns a negative number?

984

---

What are the different types of replication you can set up in sql server?

1047

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

907

---

What information is maintained within the msdb database?

973

---

Can a table be moved to different filegroup?

971

---

Which database stores information about replication?

1060

---

Can the “if update (colname)” statement be used in a delete trigger?

990

---

Why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it?

880

---