Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 Drill through query

Author  Topic 

ravilobo
Master Smack Fu Yak Hacker

1184 Posts

Posted - 2005-06-07 : 08:21:30
Drill throught queries are timing out. Any ways to fasten the same.

------------------------
I think, therefore I am - Rene Descartes

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-06-07 : 08:34:32
faster server.
less data.
index columns.
better query.
don't run them.
redesign table layouts.
better criteria.

choose any of the above options...

I might have left out something though...(and you left out any details).

Corey

Secret Service Agent: Mr. President, you're urinating on me.
President Lyndon Johnson: I know I am. It's my prerogative.
Go to Top of Page
   

- Advertisement -