Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2008-07-26 : 15:27:02
|
| Hi allCurrently i know what FileGroup is and how we can define themBut still i don't know why we should use them and what are the benefits of them.?Could anyone help me?Kind Regards.Nothing is quite impossible! |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-07-26 : 16:04:58
|
| The most benefit is to spread the IO over additional disks.That means to have a better performance.http://www.mssqltips.com/tip.asp?tip=1112WebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-26 : 21:29:21
|
| Or if you want to backup certain table(s), use table partition, ... |
|
|
|
|
|
|
Reason to use FileGroups???