SQL Server Training Video - Enterprise Manager - Put Table On Filegroup

MSSQL Server 2000 Video: Enterprise Manager - Put Table On Filegroup

This training video is brought to you by the folks at LearnItFirst, one of the web's largest training videos companies.

Enterprise Manager - Put Table On Filegroup

Description of this video:

Note: This video is from LearnItFirst.com's SQL Server 2000 Database Administration training course.

Performance tuning SQL Server often involves tuning how SQL Server stores the data and index data. This video shows you how SQL Server uses "filegroups" to control data placement. This is often a very important performance tweak and optimization for SQL Server databases. Consider this: let's say you know that 50% of your queries run against the "Customers" table, another 25% hit the "Products" table and a whopping 75% run against the "Orders" table (remember JOINs and subqueries mean it doesn't have to add up to 100%). If you could separate the Order table onto a different file (on a different drive) from the Customers and Products table, SQL Server would be able to access all three tables in parallel (depending on hardware) which means faster access to read and write data. Filegroups are the key to understanding both data and index data placement in SQL Server

Other Links You Might Be Interested In:

• Video detail page
• Course home page
• Free IT Training Videos
• Free Windows Server training videos