|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
Discuss your thoughts on the effects of indexes, data types, filegroups, and transaction logs on space considerations. Which of those database constructs do you feel are most important to manage when it comes to database size considerations? Why? What factors would you focus on when determining the actual size of these database constructs? Filegroups are used to logically group files for the purpose of maximizing performance on as many different available local physical disks as possible and to place objects into different filegroups that are competing for space. 1 You will specify the initial size of the files or filegroups during the creation of the database. When installing SQL Server, by default, the data files are allowed to grow as much as necessary until the physical disk space is used up. Therefore, you should specify the amount of space used for growth during the creation of the database using the SQL Server Enterprise Manager or the CREATE DATABASE statement.
Approximate Word count = 635
Approximate Pages = 2.5
(250 words per page double spaced)
|
|
|
|
|
|