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 |
|
zaty2405
Yak Posting Veteran
58 Posts |
 Posted - 2010-06-21 : 18:33:56
|
| Hi,I know that in order to improve performance, its better to put those heavily updated tables on different filegroup and indexes on different filegroup.My question is: 1) Do we have any best practice for filegroup allocation?2) Is there any maximum number of filegroup that can be craeted for each database ?Appreciate your reply.Thanks |
|
|
|
|
|
File allocation