I read that and I think I see your point.  However, in BOL, the implications of disabling statistics is not clear (maybe for monitoring....).

Any other take on this?

Ignacio

Well, actually his problem is that, being a Sybase fan, he is not very willing to drop it easily. Beyond the much decent tools for administering replication, what I...

Thanks for all the answers posted.  I was indeed looking for a few clues on what would be the best choice when analyzing / browsing a cube, and I think...

Thanks for clarifying!

I really dislike this kind of questions because they can easily lead to misunderstandings.  If you say to communicate with both Analysis Services Clients and OLAP Services 7.0, how the question...

I do agree. 8GB is the right answer based on the wording of the question. Will you guys at sqlservercentral correct this?

Another approach would be using the undocumented sp_MSforeachtable:

create table #spacedata

(t_name varchar(100),

t_rows int,

t_reserved varchar(50),

t_data varchar(50),

t_idxsize varchar(50),

t_unused varchar(50))

GO

sp_MSforeachtable

@command1 = "insert into #spacedata EXEC sp_spaceused '?'"