August 26, 2009 at 1:18 am
Hi SQL Gurus!
I am basically an Oracle DBA with 4yrs of experience and have bit experience with SQL Server from past 2 years. Could any one give me brief introduction about the SQL Server architecture as oracle has? I tried googling for this with no luck.
Thanks,
Nagarjun.
August 26, 2009 at 5:05 am
bommaka.nagarjun (8/26/2009)
Hi SQL Gurus!I am basically an Oracle DBA with 4yrs of experience and have bit experience with SQL Server from past 2 years. Could any one give me brief introduction about the SQL Server architecture as oracle has? I tried googling for this with no luck.
Thanks,
Nagarjun.
Not sure if this will help or not.
http://www.microsoft.com/sql/prodinfo/compare/oracle/oracledba/quickguide/01_welcome/01_quotes.htm
Generally the sqlserver site on the microsoft main site is the best place for finding resources.
http://www.microsoft.com/sqlserver/2008/en/us/default.aspx
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 26, 2009 at 7:01 am
Its similar to Oracle, few of them as per my knowledge below:
Oracle--Tablespaces,db-files, segments, extents, db-blocks
SQl-Db-files, extents(8 pages),pages(8 diff types of pages, check for them)
oracle--initial extent, next, min, max and all others
SQL-Only mixed and uniform...If a table data is less than 8 pages then it is saved in mixed else in uniform..I page = 8192 KB/8MB
SQL Doesnt have pfile and spfile, its all set using properties(server level/db level)
oracle Redo logs , rollback/undo is in SQL transactional log files.
Oracle--Data guard, SQL - Log shipping.
SQL Indexes--Only 2 types, clustered, non-clustered.
pavan.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply