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

  • September 25, 2012 at 9:15 am

    #1541933

    SQLSACT (9/25/2012)

    Hi all

    I have a quick question regarding pages moving from disk into memory

    If I select * from a table, are all pages that make up the table and indexes moved into memory?

    So any subsequent query against that same table would not need to go to disk at all?

    Thanks

    for select * there is no index and yes, all data pages would be cached into memory

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉