If you are still able to access the cube, either from SSMS or BIDS, try a full process to rebuild the structures.

Otherwise, either rebuild the whole thing from scratch...

Thanks ALZDBA! I was replying at the same time as you it seems 🙂

unixbomer (11/8/2009)

---

Paul, the article stated this about locked pages in memory and AWe:

AWE is something that is required on...

Eric Mamet (11/7/2009)

---

Is it simply a case of setting up the Max Server Memory to something like 5500 (since we share the box with the web server) and switching...

Unless the function does nothing except execute the two CASE...

Wow but that's a messy procedure. I'm not even going to start listing the things that raise red flags for me.

To answer the original question as best as I...

If it is a...

Sorry if I was less than clear: there are many ways to achieve want you want, so it would help a great deal if you could explain more about the...

Hey Adam,

Not trying to be 'smart' here...but ROLLBACK always rolls back completely, through any number of 'nested' transactions.

You might be...

Ah...that tip shows me exactly where...

You should definitely consider patching SQL Server up to a more recent cumulative update.

The issue seems to be related to statistics updates in tempdb (that what all the StatMan queries...

I've just noticed that his original query specified a NULL for the scanning mode!

I would like to see results from:

select ips.avg_fragmentation_in_percent,

...

Nice problem there Flo, and good to get it solved so quickly.

I hope other posters imitate your set-up scripts!

Paul

Hmmm well the issue is correct even if my rushed explanation there isn't quite right. The cause is still the deterministic thing, and the query plan problems still stem...

:laugh: I nearly qualified my previous response...