Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 115
Chapter 3 PHYSICAL DATABASE DESIGN AND IMPLEMENTATION 115 Each database has an owner. The owner is the user who creates the database. The database owner can be changed through sp_changedbowner. The Master database should be backed up after a user database is created. The default unit of measure for the size and maxsize settings is MB if you supply a number, but no measure is provided. If no options are supplied, maxsize defaults to unlimited and the filegrowth is 10%. At the time that you create the database and its associated files, you provide values to determine the initial file sizes, whether and how Selecting a Secure Partition When interacting with a Windows 2000 or the files will grow, as well as some other basic database and file prop- Windows NT Server operating system, erties. The initial settings are used as a basis for future file system ensure that all data is stored on an activities. If at a later date the initial settings are in need of alter- NTFS partition with appropriate secu ation, you can perform this activity through the Enterprise Manager rity measures. NTFS provides for a or by using the ALTER DATBASE T-SQL statement. flexible file system while maintaining a complete permission set for files and folders stored on disk. Using Using the Model Database NTFS partitions helps prevent file tam- When you create a database for the first time, that database initially pering and allows for more flexible takes most of its attributes from the Model database. The Model data- disk administration. base is a system database that SQL Server uses as a kind of template for database creations. It is a good and common practice to set the properties and contents of the Model database based on the majority of new databases that are to be created. NOTE IN THE FIELD OBJECT AND CODE REUSE In practice, many objects are stored in the Model database to minimize the need to re-create these objects every time a database is created. Common elements placed in the Model often include specialized user-defined functions and data types that are present and frequently used by the development staff in their coding. In theory, objects are created for use in a single database, but all developers realize that object and code reuse is an important facet of easing the development process.
For high quality website hosting services please check cheap web hosting website.