Optimizing datawarehouse

Hi,
We have a d/whse that has grown and what are the best tips
for optimizing so that response times are much quicker.
Thanks in advance.
Anon
www.sql-server-performance.com
"Anon" <anonymous@.discussions.microsoft.com> wrote in message
news:4f1b01c473e5$efbde0c0$a301280a@.phx.gbl...
> Hi,
> We have a d/whse that has grown and what are the best tips
> for optimizing so that response times are much quicker.
> Thanks in advance.
> Anon
|||Data Warehouse Tuning Guide
http://www.microsoft.com/resources/d...rt5/c2061.mspx
Using Partitions in a Data Warehouse
http://msdn.microsoft.com/library/de...itionsInDW.htm
Analysis Services Performance Guide
http://www.microsoft.com/technet/pro.../ansvcspg.mspx
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Anon" <anonymous@.discussions.microsoft.com> wrote in message
news:4f1b01c473e5$efbde0c0$a301280a@.phx.gbl...
> Hi,
> We have a d/whse that has grown and what are the best tips
> for optimizing so that response times are much quicker.
> Thanks in advance.
> Anon