TAILIEUCHUNG - Brad’s Sure Guide to SQL Server Maintenance Plans- P10

Brad’s Sure Guide to SQL Server Maintenance Plans- P10: SQL Server has a reputation as being a simple database application to install, configure, and maintain. This is a little misleading. SQL Server is a powerful relational database that can handle the needs of the largest organizations and, as such, its proper maintenance almost certainly requires the attention of an experienced DBA. | Chapter 2 Before you Create any Maintenance Plans. Figure Most of the options on this screen are optional. Summary You now have set up Database Mail and at least one operator. Now when you create a Maintenance Plan you can choose to send e-mails to an operator. In the next chapter 1 will show you how this is done. 46 Chapter 3 Getting Started with the Maintenance Plan Wizard Now that we have all the preliminaries out of the way we can focus on how to create a Maintenance Plan using the Maintenance Plan Wizard. The marketing story behind the Wizard is answer a few simple questions on some screens and voilà you have a working Maintenance Plan. Of course the reality is not quite that simple. While the Wizard does present various configuration options it does not explain what they do or their pros and cons. There is also no way to determine if the options you choose are even applicable to your situation. This chapter will provide a quick overview of the entire process of creating a Maintenance Plan from start to finish using the Wizard. I ll cover preparation how to start and how to navigate through and complete the Wizard using an example Maintenance Plan that implements the core database maintenance tasks identified in Chapter 1. I won t be going into a lot of detail this time around. Instead I will save the detail for later chapters which will show you how to implement each individual task from database integrity checking to reorganizing indexes and updating statistics and cover every possible option available. As we progress through this and subsequent chapters I ll try to anticipate and answer your likely questions and offer lots of advice and best practices on database maintenance. So while this chapter will get you started it is just a beginning. We still have a lot of hard work ahead before you know everything there is to know about using the Maintenance Plan Wizard. Finally before we start I will remind you again here as I will be reminding you throughout

• Cơ sở dữ liệu
• Phân tích thống kê với máy tính
• bảo mật cơ sở dữ liệu
• cơ sở dữ liệu Mysql
• xử lý tín hiệu
• mô phỏng dữ liệu
• SQL căn bản
• ứng dụng máy tính
• phân tích thống kê
• kiểm định giả thiết thống kê
• quy hoạch tuyến tính
• đồ thị Box
• tính toán thống kê
• phương pháp số văn bản