As you know, while running a query which counts dimension members the Management Studio do not return how many rows were returned. (for ex. select * from AW.[$Dim Product].[$Dim Product] where Color = ‘Red’ ) To solve this problem you can write a query like this: WIth MEMBER a as ([Dim name].[Attribute]. members ). count SELECT a on 0 from [$dim name] =========================================== WITH MEMBER a as ([Dates].[Date ID]. members ). count SELECT a on 0 from [$Dates]
in the attached file you can find queries about Blocking, DiskIO, Memory, Running Queries, Indexes etc ... Itay Braun Premier Field Engineer - SQL Server and BI Microsoft Services - UK E-Mail: itayb@microsoft.com Mobile: +44-796-928-9996 Blog: http://sqlblogcasts.com/blogs/thepremiers/ Veni Vidi Fixit