Post reply

How SQL Server DB Engine will handle a transaction?

  • August 7, 2008 at 5:15 am

    #382173

    If we issue a DML statement aganst the sql server what are all the different steps will carried by sql server.

    mean to say first the DML will be written to Buffer cache or Log file all these steps i required....

    if any good urls or books please suggest me...

  • August 7, 2008 at 6:32 am

    #854399

    Pick up a copy of Kalen Delaney's Inside SQL Server 2005: The Storage Engine. That will give you a lot of the kind of information that you're looking for.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • August 7, 2008 at 8:49 am

    #854503

    Awesome book, got it right here on my desk. 🙂

Viewing 3 posts - 1 through 3 (of 3 total)

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