Build your professional network on facebook via our app Go to app
 
 
 

Oracle 11g vs. Microsoft SQL Server 2008

Created by : Anuj Mishra, Sales/BD Manager, Infosys  | 09 21 2008 19:33:49 +0000
Industry : IT ProductsFunctional Area : Product Development(Operations)
Keywords : SQL Server 2008 Oracle 11G MICROSOFT SQL
Activity:  4093 views;  last activity : 10 20 2010 08:36:10 +0000
Oracle and Microsoft are always fighting for the top spot in database wars. A few years back it was very simple, if you had mainframes and IBM hardware DB2 was the database, if you had Unix like operating systems, Oracle was the database and if you had Windows operating system, SQL Server was the database. However, over the years, each database has grown in capabilities and the lines are blurred now.Lets compare some features of these technologies today.
  
Share
 
 
  Rate : 
 
 
Oracle 11g Vs Microsoft SQL Server 2008
10
 
 
 
 
9
4
4
Support   Support
Top Argument
1
0
i think one of the amazing features is that Oracle Enterprise Manager follows the management-by-exception model, where DBA intervention is only needed when an exception condition occurs or is about to occur. Oracle Database 11g provides a built-in, push-based alerting mechanism that is extremely efficient and accurate. Oracle highlights problem areas, such as performance issues, so that potential problems can be identified and often dealt with before the problem negatively impacts end users. This differs significantly from SQL Server 2005 where DBAs themselves have to monitor the system for potential problems.
By Anuj Mishra, Sales/BD Manager, Infosys  09 21 2008 19:33:49 +0000
 
Top Argument
1
1
· Sparse columns efficiently manage empty data in a database because they enable NULL data to consume no physical space. SQL Server 2008 sparse columns can support wide tables that have up to 100,000 columns, whereas Oracle’s current limit is 1,000. Column sets support property-bag scenarios in content management systems such as Office SharePoint Server.
By Surya Prakash, Sales/BD Manager, Oracle  09 21 2008 19:34:39 +0000
0
0

I work for Oracle & SQL Server, Mostly i can see SQL Server has implemented the Oracle Core methods like Schema based system, merge statements, ..... I can saw oracle is MASTER COPY.

 
By Thanigachalam T, Database Developer, Zeomega  | 03 10 2010 01:56:42 +0000
0
0

Oracle is Oracle...
By Khalid Mehmood Awan, asdfasf, asdfasfsdf  | 07 13 2009 03:53:35 +0000
1
0

I definately recommend Oracle 11g even though I never used it. You short description dose give all answer of your question. Oracle is a very powerful, reliable and secure database . No doubt sql server 2008 also have those capibilties. It's good to use sql server if u using microsoft tools. Other wise better to go with oracle or DB2 depends on ur requirement.India MTNL using oracle products for their database. So,I relaized why oracle so demanded..... Just look the MTNL orgainsation.... and their services every data recorded in oracle database. But If you want to use sharpoint,biztalk or Micorosft SOA development then better to use sql server 2008 beucase they SSIS,SSRS and number of other fatures which help to developmet.

 
By Alok Saxena, Designer cum Team Leader -(Technical), ATOS ORIGIN (PRINCE2 2009)  | 06 01 2009 20:43:24 +0000
0
0

Price, price and price again.

MS SQL 2008 R2 even in standard edition has more features than Oracle Standard.

MS SQL license is affected by physical CPU only , not by amount of cores in CPU.

 

So why should I pay twice and more for less functionality?
By Ray Adams, Senior Software Developer, Simbrella  | 10 20 2010 08:36:10 +0000
1
0

I would still go with SQL Server 2008 even though it won't provide facility to highlight potential performance problem. The main reason to choose the backend should be the internal structure, mechanism that database system provide to give stability, performance and flexibility to the developers as well as users. And SQL Server 2008 already provides all of these. Highlighting problems doesn't prove efficiency of your system.
By Parth Patel, Software Engineer, Clarion Technologies Pvt. Ltd.  | 05 28 2009 04:06:09 +0000
1
0

I would still go with SQL Server 2008 even though it won't provide facility to highlight potential performance problem. The main reason to choose the backend should be the internal structure, mechanism that database system provide to give stability, performance and flexibility to the developers as well as users. And SQL Server 2008 already provides all of these. Highlighting problems doesn't prove efficiency of your system.
By Parth Patel, Software Engineer, Clarion Technologies Pvt. Ltd.  | 05 28 2009 04:05:34 +0000
Argue for "Oracle 11g"
Argue for "Microsoft SQL Server 2008"
 Found the debate "Oracle 11g vs. Microsoft SQL Server 2008"  interesting ?  Suggest to your connections and communities  
Leading Recruitment Firm
Leading Recruitment Firm
Viewers also viewed
Dynamic Management Views   The dynamic management views (DMV’s) in SQL Server 2005 are designed...
 
11 referals 6 comments, 1828 views
Hi ,i want to do certification in oracle but i don't have appropriate idea about the...
 
1 referals 1 answers, 94 views
Windows the very word which changed how we use our PC's and other Computer or laptop related...
 
1317 referals 32 arguments, 485 views
more...  
Recent Knowledge (3)
WE HAD A GOOD NUMBER OF INVENTORS WITH GREATER VISION ABOUT THE SOCIETY. INVENTORS HERE NEED NOT...
 
2 referals 2 arguments, 97 views
These days as I switch on the tv or radio or look at a hoarding I do feel that power of ads I...
 
3004 referals 23 arguments, 482 views
MNC's should take in more freshers vs Do not take freshers
 
1 referals 2 arguments, 161 views
more...  
Sponsored Jobs
More From Author
I agree with your idea that one should be patient while negotiating. I have come across many sales representative who are just in hurry and makes a wrong decision and never negotiates successful...
During negotiation the Sales person would be asked to give their best price so that the buyer can buy what he/she is selling. Once the seller gives his best price he will be shocked to find out that the buyer wants more. Nothing can be done in such...
According to me, use of small teams and projects is very important, in order to avoid a project failure. And this helped the team tremendously and it delivered the project successfully to the customer. And other big companies who are having an...
more...  
  • Popular Knowledge
  •  
  •  
  • Popular Jobs
  •