Automatic options for SQL Server databases

Automatic options affect what SQL Server might do automatically, all of which are bool values, with a value of on or off

1.

Auto_Close:

When this is on, the database shuts down completely after the last user exits, so the database does not use any memory.

2.

Auto_shrink:

When this is on, all database files may be periodically shrunk.

3.

Auto_create_statistics

When this is on, the SQL Server query optimizer automatically creates the Bibi statistics.

4.

Auto_update_statistics

When this is on, if the table's data changes, the existing statistics are also updated, and SQL Server retains the registers for the table modifications.

--------------------------------------------------------------------------------------------------------------- -------

Automatic options for SQL Server databases