Which table keeps information about stored procedures?

984

---

How is a full-text index updated?

1002

---

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

1003

---

How can you find out how many rows returned in a cursor?

1086

---

What is the difference between writing data to mirrored drives versus raid5 drives

989

---

How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?

1076

---

Give an example of why you would want to denormalize a database

1031

---

How many full-text indexes can a table have?

1026

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1082

---

What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?

1194

---

What is the importance of concurrency control?

1273

---

How you can get the list of largest tables in a database?

1065

---

When you should use a low fill factor?

1036

---

Define cursor locking

1061

---

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

1017

---