sql server data warehouse: 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.

www.sql-server-performance.com


[quoted text, click to view]

Data Warehouse Tuning Guide
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part5/c2061.mspx

Using Partitions in a Data Warehouse
http://msdn.microsoft.com/library/default.asp?URL=/library/techart/PartitionsInDW.htm

Analysis Services Performance Guide
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/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

[quoted text, click to view]