O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing Database Settings

You use the Database Settings page of the Server Properties dialog box to configure server-wide database settings. As shown in Figure 6-7, you can use this page to set index fill, backup and restore options, and recovery intervals for checkpoint execution.

The Database Settings page of the Server Properties dialog box

Figure 6-7. The Database Settings page of the Server Properties dialog box

Setting the Index Fill

The default index fill determines how much space SQL Server should reserve when it creates a new index using existing data. Setting the fill factor involves a tradeoff—if you set the fill factor too high, SQL Server will slow down when you add data to a table. However, if you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required