How is the Autogrowth setting used on data files and log files and what is a best practice for this setting?
What will be an ideal response?
The Autogrowth setting specifies how much the database will increase the size of the physical files once the space that was initially allocated to them becomes full; the Autogrowth setting can be stated in absolute or relative terms. The defaults are 1 MB for the data file and 10 percent for the log file. Due to the performance impact of increasing the size of the files, you should make these settings sufficiently large to make file growth a very infrequent event.
You might also like to view...
In a SELECT statement the ________ clause can be used to sort the rows.
A) SORT B) WHERE C) ORDER D) ORDER BY
Any action that can be detected by a program or computer system, such as clicking a button or closing an object, is considered an object
Indicate whether the statement is true or false