tailieunhanh - Hướng dẫn học Microsoft SQL Server 2008 part 93

SQL Server có rất nhiều tùy chọn cấu hình. Những khó khăn trong việc làm chủ chúng nằm trong thực tế rằng họ đang trải rộng trên ba cấp độ: Server cấp các tùy chọn cấu hình chung như thế nào làm việc với máy chủ phần cứng, và xác định cơ sở dữ liệu mặc định. | Configuring SQL Server iw ww SQL Server has a plethora of configuration options. The difficulty in mastering them lies in the fact that they are spread across three levels Server-level options generally configure how the server works with hardware and determine the database defaults. Database-level options determine the behavior of the database and set the connection-level defaults. Connection-level options determine the current behaviors within the connection or current procedure. Several of the configuration options overlap or simply set the default for the level immediately below. This chapter pulls these three configuration levels into a single unified understanding of how they relate to and affect each other. This chapter does not cover every single SQL Server configuration option but it covers most of them that I think are important. If you are a SQL Server beginner you may find that some of the configuration options are advanced and you may not need them immediately. IN THIS CHAPTER Making sense of SQL Server configuration Configuring the server-level configuration options Configuring the database-level configuration options Configuring the connection-level options Setting the Options Whether you choose to adjust the properties from SQL Server Management Studio s graphical tool or from code is completely up to you but not every property is available from Management Studio using the graphical interface. While the graphical interface has the advantage of being easy to use and walks you through easily understood dialogs that prompt for the possible options in a pick-and-choose format it lacks the repeatability of a T-SQL script run as a query. To view miscellaneous information about the computer system while configuring SQL Server query the dynamic management view. 883 Part VI Enterprise Data Management New in SQL Server 2008 Configuration SQL Server 2008 offers many new configuration options such as