You’re getting ready to buy more drives, but what should you use them for? If you’re a developer designing a database schema or a production DBA configuring storage, maybe you’ve thought about putting indexes on a separate filegroup.
I’ll explain when it’s right to add more files, the difference between filegroups and files, and why you probably shouldn’t separate out indexes into their own filegroup — but what should go into those new filegroups? You’ll learn in this 33 minute video:
Liked that video? Here’s some of our past videos that you can watch immediately: