Post reply

Storage Structure for Datawarehouse

  • 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

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply