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,

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,

best place to start

I am fairly versed with SQL 2005 as I have been using it since it came out. Now I have need to learn about Cubes.

Does anybody have any suggestions of where I need to begin to learn about what cubes are, how to create them and use them?

Ultimately we will be incorporating them into Reporting Services.

Thanks for the information.

Using Books Online, look up the Topic: SQL Server 2005 Analysis Services Tutorial

There are some excellent sections on Cubes.

|||Thanks for the information.