Chris Webb's BI Blog

Analysis Services, MDX, PowerPivot, DAX and anything BI-related

Using the Create Cache statement

with one comment

Another interesting article from the SQLCat team on using the Create Cache statement:
 
I’m not sure why they say that it was introduced in SP2 since this has been around at least since AS2K and possibly before. Interestingly someone asked me only two days about this functionality and I’d completely forgotten about it despite all the work I’ve done on cache warming recently; I assumed it had been dropped in AS2005 (perhaps it had and maybe it’s only been reintroduced in SP2?). I played around with it a lot a few years ago on AS2K and never found it had any benefit but perhaps the architectural changes have rendered it more useful… I must update my cache-warming package to make use of this. There’s also a WITH clause variant too that isn’t mentioned in the article (although it’s in AS2K BOL) which needs further investigation too.
 
Lastly this article also mentions a new connection string property I’ve heard about which again was introduced recently, Disable Prefetch Facts.

Written by Chris Webb

April 26, 2007 at 9:04 am

Posted in MDX

One Response

Subscribe to comments with RSS.

  1. > perhaps it had and maybe it\’s only been reintroduced in SP2?
     
    Precisely ! AS2005 supported syntax of CREATE CACHE – but did nothing. SP2 reintroduced the actual functionality.

    Mosha

    April 26, 2007 at 10:01 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 3,299 other followers

%d bloggers like this: