Click here to monitor SSC

Any book(SQL 2000 or SQL 2005 or SQL 2008) which contains the detailed information about the Transaction Log

Last post 01-05-2011, 1:51 AM by mrphantuan. 4 replies.
Sort Posts: Previous Next
  •  05-13-2008, 12:20 AM Post number 52726

    • baddy is not online. Last active: 10-30-2008, 5:49 AM baddy
    • Top 50 Contributor
    • Joined on 04-07-2008
    • India
    • Blue Gene

    Any book(SQL 2000 or SQL 2005 or SQL 2008) which contains the detailed information about the Transaction Log

    Can you please suggest me any book(SQL 2000 or SQL 2005 or SQL 2008) which contains the detailed information about the

    a) Transaction Log (means the algo how transaction log stored data information during DDL or DML statements)

    b) Pages and Extends, Detailed information about the all type of pages like Data Page, Index Page, and Text/Image Page.

    I found number of article from the net but didn’t provide the detailed information.

    Thanks,

    Baddy

  •  05-14-2008, 1:47 PM Post number 52956 in reply to post number 52726

    • Granted is not online. Last active: 03-07-2011, 3:25 PM Granted
    • Top 75 Contributor
    • Joined on 07-06-2006
    • People's Republic of Massachusetts
    • Level 1: Deep thought

    Re: Any book(SQL 2000 or SQL 2005 or SQL 2008) which contains the detailed information about the Transaction Log

    For the 2000 area, either Ken Henderson's The Guru's Guide to SQL SErver Architecture and Internals or Kalen Delaney's Inside SQL Server 2000. For 2005, the only one that I know of that comes close to what you're asking for is Kalen Delaney's Inside Sql SErver 2005: The Storage Engine.
  •  05-15-2008, 8:11 AM Post number 53027 in reply to post number 52956

    Re: Any book(SQL 2000 or SQL 2005 or SQL 2008) which contains the detailed information about the Transaction Log

    You should have the late Ken Henderson's book anyway because it is such fun to read.
  •  05-15-2008, 9:35 AM Post number 53034 in reply to post number 53027

    • Granted is not online. Last active: 03-07-2011, 3:25 PM Granted
    • Top 75 Contributor
    • Joined on 07-06-2006
    • People's Republic of Massachusetts
    • Level 1: Deep thought

    Re: Any book(SQL 2000 or SQL 2005 or SQL 2008) which contains the detailed information about the Transaction Log

    Yet another reason to regret his passing. His books really were enjoyable to read which is exceedingly rare in the technology sphere.
  •  01-05-2011, 1:51 AM Post number 97696 in reply to post number 53027

    Re: Any book(SQL 2000 or SQL 2005 or SQL 2008) which contains the detailed information about the Transaction Log

    Phil Factor:
    You should have the late Ken Henderson's book anyway because it is such fun to read.

    I think so!

View as RSS news feed in XML