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 2:59 am

    #892200

    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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass