Database options you can specify how the database behaves in some situations. You can view and edit the database with the options of Management Studio or ALTER DATABASE. Leave the options database currently on the database that you created earlier defined AdventureWorks (Example database after you install MS SQL Server).Start Management Studio and moving in the database until the console. Click on the database and select Properties. In the Database Properties pane, click Options, as Picture below
The Options Page
- Collation this indicator for the collation of the database.
- Recovery Model can choose between three models of the subsequent recovery.
- Compatibility Level this option changes the way we behave database that is running compatible with earlier versions of SQL Server. The three levels of compatibility between SQL Server 7.0 (70), SQL Server 2000 (80) and SQL Server 2005 (90).
- Auto Close option secure database where the user has left. This can be a useful option for the optimization of databases that are available often, it reduces the amount of funds to eat SQL Server to your information and locks must adhere. This should be up to databases that can be accessed frequently because of the opening set of the database outweigh the benefits of the closure of the first database.
- Auto Create Statistics automatically generated statistics on the distribution of values found in his columns. SQL Server query optimizer uses these statistics to determine the best path to a particular query.
- Auto Shrink reduces automatically reduce the data and log files. Log files are reduced by a log backup. The files will be for your eyes regularly decreased from the database that the database has more than 25 percent of its allocated space for free. Your database size will be allowed to 25 percent, to be free reduced.
- Auto Update Statistics option works with the Auto Create Statistics. If you make changes to data in its database, the statistics are less precise. This option regularly updated statistics.
- Auto Update Statistics Asynchronously option works with the Auto Create Statistics. If you make changes to data in its database, the statistics are always accurate. This option will be regularly updated statistics.
- Close Cursor on Commit Enabled option to "true" to open any cursor closes when opening, promised the transaction or canceled. If false, the cursor remains open when the transaction is guaranteed and will be closed when the transaction is aborted.
- ANSI NULL Default option specifies the default value for NULL comparisons ANSI. Whenever, any query that returns a null value compares a null When off, any query that compares a null value-null return.
- ANSI NULLS Enabled specifies whether ANSI NULLS are on or off for the database.
- ANSI Padding Enabled option is set to true, if you store data in a column that is
less than the column width, then the remaining data is filled in with trailing blanks. When set
to false, any remaining data is trimmed off. - ANSI Warnings Enabled option is set to true, a warning is generated when a null value is used
in an aggregate function (like SUM or AVG). When false, no warning is generated. - Arithmetic Abort Enabled option this is set to on, a divide-by-zero error will cause a query
to terminate. If this is off, the query will continue but a message is displayed. - Concatenate Null Yields Null option specifies that anything you concatenate to a null
value will return a null value. - Date Correlation Optimization Enabled option is set to on, SQL Server maintains
statistics between any two tables in the database that are linked by a FOREIGN KEY constraint
and have datetime columns. When it is set to off, correlation statistics are not maintained. - Numeric Round-Abort option is set to on, a loss of precision will generate an error message.
When it is off, a message will not be generated. - Parameterization option is set to Simple, SQL Server may choose to replace some of the
literal values in a query with a parameter, but you have no control over what is changed into
a parameter. When set to Forced, all literal values are replaced with a parameter. - Quoted Identifiers Enabled option allows you to use double quotation marks as part of
a SQL Server identifier (object name). This can be useful in situations in which you have identifiers
that are also SQL Server reserved words. - Recursive Triggers Enabled option allows recursive triggers to fire. Recursive triggers
occur when one trigger fires a trigger on another table, which in turn fires another trigger on
the originating table. - Page Verify option controls how SQL Server verifies the validity of each page in the
database. This setting has three options:
None No verification takes place.
Checksum A mathematical calculation is run against all of the data on the page and the
value (called the checksum) is stored in the header. When the mathematical calculation is
run again, if the result does not match the checksum value, then the page is damaged.
TornPageDetection The smallest unit of data SQL Server works with is 8KB, but the
smallest unit of data that is written to disk is 512 bytes. This means parts of a page may not
be written to disk, a condition known as a torn page. This option allows SQL Server to
detect when this problem occurs. It is not as accurate as checksum, but it can be faster. - Database Read-Only option is set to true, this option marks the database as read-only. No changes
to the database will be allowed. This is usually set to speed up access to archival data that will
never be written to.
Post a Comment