----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: VaibhavModak Message 2 in Discussion Hi, File groups are used to manage the System files (data and log files) created by SQL Server 2K. By putting the files under filegroups you can group and control where to put all the data files over which the data is placed. If the filegroup comprises multiple files spread across various physical disks, each with its own disk controller, then queries for data from the table will be spread across the disks, thereby improving performance. Similarly you can also place tables having similar structure under one file group for better File IO. For eg if you have data comprising of text, ntext, image type, you can place them under one file group to help improve performance. For more details pls visit the following site: SQL Server 2000 Administration in 15 Minutes a Week: Database Creation Basics http://www.databasejournal.com/features/mssql/article.php/1433041 You can also check the details regarding the Filegroup concept in SQL Books Online(BOL). Search for "File and Filegroups" or "Physical Database Files and Filegroups" HTH, Regards, Vaibhav Modak ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
