Understanding the Algorithms used by SQL Server

  •  I have been a DBA for three years.  Over the past three years, I've been rapidly increasing my skill set in standard administration and programming.  However, I know that there is a huge gap in my understanding of SQL Server and how it really works.  I'm in graduate school right now and I'm taking a course in Algorithm and Design.  I have to write a research paper on some topic that deals with Algorithm and Design and I figured this is as good of time as any to really understand the Algorithms that SQL Server uses to make the decision on how to retrieve data, store data and etc.

     

    Before I go off on this journey, I would like to know if I am going to be able to find out how SQL Server really works?  Does microsoft actually discuss the algorithms that they use for data retrieval, storing data and etc?  Do you all think that the research into the internals of SQL Server will be useful as a DBA?  If you all could recommend good books and/ or articles that provide details about this topic, then that would be great.

  • You might want to read Ken Hendersons "The Guru's Guide to SQL Server Architecture and Internals", just starting that myself.

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

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