Post reply

Image column - How to put a where clause

  • January 18, 2010 at 2:11 pm

    #1105135

    You're welcome. So what's the difference in page reads?

  • January 18, 2010 at 4:18 pm

    #1105177

    I can see that the execution plan is no longer retrieving the image column. I know the avg. reads will go down significantly considering only the non-clustered indexes are being retrieved.

    I have a little wait for the next hotfix to put in this change and then for the next performance analysis with PSSDiag to know the Avg. Reads. I will PM you when its done.

    Thanks again.

  • January 19, 2010 at 4:18 am

    #1105319

    Please post those stats here, that way we all benefit from your experience.

  • January 19, 2010 at 7:47 pm

    #1105797

    Sure thing!

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply