• GilaMonster (9/17/2014)


    andrew gothard (9/17/2014)


    It's a bit wasteful on RAM, holding all your hot index pages twice, as well as any you're not using in RAM anyway. Puzzled as to how this approach will "greatly improve performance" - does this person work for a spectacularly unscrupulous RAM vendor by any chance?

    Considering that the rest of the recommendations on that page were either complete hogswash or based on busted myths...

    What I didn't copy was, at the beginning of his set of RAMDisk based recommendations was Microsoft was stupid for removing PinTable because using it was so crucial to good performance, therefore here's how to get around that removal.

    I have to ask, this article wasn't by any chance posted on 1st of April was it?

    I'm a DBA.
    I'm not paid to solve problems. I'm paid to prevent them.