FAQs

Q.		Can I store my database files on a compressed drive to save space?
A.		No. Microsoft recommends that you do not put any of the files on a compressed drive. The compression and decompression process will impact the performance of SQL Server and can cause database integrity problems.
Q.		Do I have to use Enterprise Manager to create my databases, tables, and other objects in SQL Server 2000?
A.		No. Enterprise Manager provides graphical design tools and wizards, but you can also use T-SQL to write scripts to create all your database objects in SQL Server. Many administrators prefer using T-SQL scripts because they can be backed up and reused.
Q.		What are all the databases that are installed with SQL Server 2000? Can I delete them all?
A.		No. SQL Server includes four system databases that cannot be deleted or your database server s stability will be impacted. These system databases are msdb, Model, TempDB, and Master. The remaining two databases that are installed with SQL Server are the Pubs and Northwind databases. These are sample databases that can be deleted without affecting SQL Server.
Q.		Where should I place my transaction log file? Can I use more than one?
A.		Transaction log activity is sequential and primarily writes. For this reason, you should isolate your transaction log on a separate physical disk to minimize read/write head movement and eliminate contention over data file activity. Additionally, you can place your...

< Previous Excerpt Next Excerpt >

Designing SQL Server 2000 Databases for .NET Enterprise Servers