Set the SSFastLoadOptions registry key (needed to create it) to ""
(empty string) as described in:

http://msdn.microsoft.com/library/de...lwriteback.asp

After reboot, running the UPDATE CUBE statement that worked before
(very slowly worked), I receive the following error(s):

Incorrect syntax near ''.
Cannot use empty object or column names. Use a single space if
necessary.

----------------------

Does anyone know what is going on here and how to resolve these
errors? I was unable to find any additional resources on this topic.

Thanks.

Michael.

Update:

Using "TABLOCK" instead of "" (empty string) stopped this error from
occuring (it seems that the SQL query generated by the AS server was
leaving a WHERE clause blank, hence the error), but did not speed up
the UPDATE command to less than 60 seconds (for 200x200 leaf nodes).
I was wondering if this is to be expected.

Also, would an increase in RAM on either the AS server or the SQL
server help to speed up the UPDATE CUBE command? On which server
would it be more effective?

Thanks.

Michael.

mmarano (AT) resourceconsultants (DOT) com (Michael) wrote in message news:<a478254e.0312161124.2e28ae11 (AT) posting (DOT) google.com>...