August 19, 2006 at 8:16 am
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.
August 19, 2006 at 12:49 pm
The most 'low' level information about SQL Server that is available to the public is probably the book Inside SQL Server 2000.
I'd contact Microsoft with your question if I were you.
August 20, 2006 at 2:23 am
I agree with the above post .... the best insider info available is in the book Inside SQL Server 2000. but then it only talks about overview of the process, forget the algortihms used. My suggestion is that if you want to know the algorithms used for simple tasks for an RDBMS, then try any of the open source databases. For SQl Server in particular, contacting Microsoft is your best bet.
-------------------------------------------------
-Amit
Give a man a fish and he'll ask for a lemon. Teach a man to fish and he wont get paged on weekends !! :w00t: - desparately trying to fish [/size]
August 20, 2006 at 5:23 pm
Thanks for you response
August 21, 2006 at 12:13 am
I'd also recomend 'The Guru's guide to SQL Server Architecture and Internals' by Ken Henderson
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply