Description:

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

Download and watch this video