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

1005

---

What is a fill factor?

1036

---

How can you find out which stored procedures are recompiling?

883

---

What is a transaction and why is it important?

1005

---

Explain a differential backup?

949

---

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

917

---

What are the advantages dts has over bcp?

945

---

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

943

---

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

988

---

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

857

---

What information is maintained within the msdb database?

928

---

Can a table be moved to different filegroup?

920

---

Which database stores information about replication?

991

---

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

946

---

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

823

---