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.
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 ...
Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
