471
Chapter 19: Confi guring SQL Server
19
Confi guring the Server
The server-level confi guration options control server-wide settings, such as how SQL Server
interacts with hardware, how it multithreads within Windows, and whether triggers are
permitted to fi re other triggers. When confi guring the server, keep in mind the goals of
confi guration: consistency and performance.Graphically, many of the server options may be confi gured within the Server Properties
page, which you can open by right-clicking a server in the console tree and choosing
Properties from the Context menu. The General tab in Management Studio’s SQL Server
Properties dialog box (see Figure 19-1) reports the versions and environment of the server.FIGURE 19-1
The General tab of Management Studio’s Server Properties dialog.The same information is available to code. For example, the version may be identifi ed with
the @@VERSION global variable:select @@VERSION;c19.indd 471c19.indd 471 7/30/2012 5:42:46 PM7/30/2012 5:42:46 PM
http://www.it-ebooks.info