The database size option determines the default size of a ew database. In most cases, you will be fine with the default of 2MB. Dataases will dynamically grow in size, so it is not advisable to change this parameter in order to consume the smallest amount of space on a server. If all of the database you will create on a server will be larger than a certain size, you will see a slight performance gain e allocating the space during the creation.

default comparison style

The default comparison style controls the sorting options within a locale used for Unicode character sets.

default language

SQL Server has the ability to run with multiple language sets. The default langauge determines what langiage SQL Server will use. The default setting is always US English.

default locale id

The default locale id specifies the locale to use for sorting Unicode character data.

default sortorder id

The default sortorder id specifies the order SQL Server will sort data in. This option is set during the installation of SQL Server and can not be changed. If you need to change the sort order, you will need to unload and reload all of your data. This is necessary, because you can not restore a backup from a server with a different sort order. The default is dictionary order, case insensitive.

fill factor

The fill factor forces SQL Server to reserve space in an index when it is built. The value set at the server level applies to all indexes created unless the fill factor is explicitly specified in the crate index statement. Unless you have very static data whose modification is tightly controlled, you will want to use a fill factor. This allows for a certain amount of growth in the index before page splitting is necessary. The fill factor is established when the index is created and is not maintained.

language in cache

The language in cache option controls the number of languages that SQL Server can store in the language cache simultaneously.

locks

The locks setting controls the number of locks allocated to the lock manager. You should set this value to 0 and leave it there. A value of 0 allows the lock manager to dynamically allocate memory for locks as needed. Each lock will consume 32 bytes of memory space. When SQL Server is started, 2% of the available memory is allocated to locks. Once this is used up, additional memory is allocated up to a maximum of 40%.

max async io

Max asynch io controls the maximum number of asynchronous I/O requests that the SQL Server can make to the hardware devices. YYou should only change this if you have more than 8 physical disks on the system and performance is suffering from the amount of disk processing occuring.

SQL Server 7.0 Server, Database, and Query options 1 2 3 4 5 6 7 8