Microsoft® SQL Server® 2012 Bible

469

CHAPTER

19

Confi guring SQL Server

IN THIS CHAPTER

Making Sense of SQL Server Confi guration

Confi guring the Server-Level Confi guration Options

Confi guring the Database-Level Confi guration Options

Confi guring the Connection-Level Options

S

QL Server has a plethora of confi guration options. The diffi culty in mastering them lies in the

fact that they are spread across three levels:

■ (^) Server-level options generally confi gure 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 confi guration options overlap or simply set the default for the level immediately
below. This chapter pulls these three confi guration levels into a single unifi ed understanding of
how they relate to and affect each other. This chapter does not cover all SQL Server confi guration
options but covers most of the important ones. If you are a SQL Server beginner, you may fi nd that
some of the confi guration options are advanced, and you may not immediately need them.

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. Although the graphical interface has the advantages of being easy

to use and walks you through easy-to-understand 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.

c19.indd 469c19.indd 469 7/30/2012 5:42:42 PM7/30/2012 5:42:42 PM

http://www.it-ebooks.info