Storage Structure for Datawarehouse

• sehgalnamit

  SSC Eights!

  Points: 813

  More actions

  April 13, 2011 at 12:59 am

  #249288

  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?

• April 13, 2011 at 3:13 am

  This was removed by the editor as SPAM

• Jody.WP

  Mr or Mrs. 500

  Points: 518

  More actions

  April 13, 2011 at 3:34 am

  #1310886

  Please read this

  http://msdn.microsoft.com/en-us/library/dd939169%28SQL.100%29.aspx ,

  also you check check opout the white paper guide to MS fastrack data warehouse architecture