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.
Anonwww.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/...r />
2061.mspx
Using Partitions in a Data Warehouse
http://msdn.microsoft.com/library/d...nDW.
htm
Analysis Services Performance Guide
http://www.microsoft.com/technet/pr...n/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.
> Anonsql