Home Forums SQL Server 2008 SQL Server 2008 Administration SQL Disk to Memory RE: SQL Disk to Memory

  • September 26, 2012 at 8:47 am

    #1542469

    GilaMonster (9/26/2012)

    SQLSACT (9/26/2012)

    This whole post is under the assumption that we're only querying data, we are not doing any Inserts, Updates or Deletes, right?

    No, not really.

    Thanks

    If SQL needs to insert/delete a rows on a specific page, that page is brought into memory and the insert/delete is done in memory?

    Does that page then stay in memory?

    Thanks