Best practices for partitions for cubes?

Hi, all here,

Thank you very much for your kind attention.

Would please any experts here give me any guidances and advices for what are best practices for partitions for cubes in SQL Server 2005 analysis services? I mean like when should we use partitions for cubes? And what are the best practices for the partitions memory modes?

Thanks a lot in advance for any helpful guidances and advices for that.

With best regards,

Yours sincerely,

Hi,

This link will give you a good introduction to partitioning

http://www.microsoft.com/technet/prodtechnol/sql/2005/projreal.mspx

|||

Hi, Larrybird02744,

Thank you very much for your kind guidance.

With best regards,

Yours sincerely,