Free SQL Server 2000 Video Tutorial: Enterprise Manager - Put Table On Filegroup

Enterprise Manager - Put Table On Filegroup - download

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

• Category: SQL Server Videobooks
• Skill Level: 400 (Intermediate - Advanced)
• Length: 14:47 (8.40MB)
• Source Videobook Entry (Subscriber-only version)

---

To download this video, visit the Free Videos page, click "download" and enter the correct security code.

Note: You must have the TSCC codec installed to view this video