Home Forums Article Discussions Article Discussions by Author Discuss content posted by Gail Shaw Managing Transaction Logs RE: Managing Transaction Logs

  • October 31, 2008 at 4:54 am

    #892232

    GilaMonster (10/31/2008)

    Chirag (10/31/2008)

    Thank you Gail. That explains things clearly. So would the same apply to BLOB data. Would BLOB data be brought into memory and then modified?

    Exactly the same. The query processor can only operate on pages in memory. The query processor has no knowledge of the disks and no ability to interact with the disks. That's what the storage engine does.

    Thank you once again.

    "Keep Trying"