Tuesday, August 05, 2008

SSAS: Query Performance Tuning Whitepaper

 

For those of you with the assembly from the Analysis Services Stored Procedure project installed you can go one step further and use the following.

CALL ASSP.ClearCache("Adventure Works")
GO
SELECT {} ON 0
FROM [Adventure Works]

SSAS: Query Performance Tuning Whitepaper

No comments: