Review

3 4

Here are some questions to help you determine whether you have learned enough to move on to the next chapter. If you have difficulty answering these questions, review the material in this chapter before beginning the next chapter. The answers for these questions are located in the Appendix, "Questions and Answers."

1. You are running a number of server applications on the same computer. You observe that the performance of SQL Server 2000 is initially poor after a period of low activity. What can you do to improve its responsiveness?
2. You want to configure the SQL Server Agent service to send mail to administrators in response to alerts. What is the first task you must perform?
3. You want to enable one of your databases to be queried using XML. What must you do?

Answers