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 |
|
veggiop
Starting Member
10 Posts |
 Posted - 2011-04-13 : 05:48:11
|
| I am looking for msdn article where Microsoft recommends to use:-1. Different Filegroups for non cluster indexes.2. Nultiple datafiles increase performance when our database is large (200 GB ore mor). How can we decide the size of each file?3. We should not store our actual user data in .mdf file to help DB to be online when there is a corruption in any of the filegroup other than PRIMARY.4. How can we decide our pagefile sixe when our RAM is 200 GB in Windows 2003? |
|
|
|
|
|
Storage Structure for Datawarehouse