Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 sql server architecture

Author  Topic 

sri.lakshmi
Starting Member

1 Post

Posted - 2012-01-12 : 00:31:04
I'm new to sql server. CAn anyone suggest me in getting exact sql server architecture to understand how it works.


jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-01-12 : 01:39:47
A good starting point is to download and read SQL Server Books Online - which has some good articles on the architecture.
A good book is the SQL Server 2008 Internals through MS Press - focusing more on the Database Engine


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2012-01-12 : 05:01:50
Though if you're a newcomer, I'd suggest stay away from SQL Server 2008 Internals. It's a book aimed at people experienced with SQL, it may well be over your head.

What are you actually looking for? I could describe the architecture, but that wouldn't necessarily make any sense to someone completely new so...???

--
Gail Shaw
SQL Server MVP
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2012-01-12 : 06:07:08
quote:
Originally posted by sri.lakshmi

I'm new to sql server. CAn anyone suggest me in getting exact sql server architecture to understand how it works.


As per comments above.

If you are only new to SQL SERVER but have a good working knowledge of how other relational database product work then that one thing: start with SQL SERVER 2008 internals.

If you are new to relational databases entirely then that's a completely different container of animals

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-01-14 : 15:40:15
Someone who is experienced in Oracle or DB2 internals - should be able to read SQL Server 2008 Internals and understand the concepts

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -