Build your professional network on facebook via our app Go to app
 
<< Prev  3 of 4 in Topic  Next >>
Topic : Clustering in SQL Server
  Rate : 
Posted in Community :

Database Administration

 

SQL Server vs Oracle

Created by : Raji S, Business Analyst, SAP  | 08 16 2008 01:12:52 +0000
Industry : IT ProductsFunctional Area : Application Software(Technology)
Keywords : SQL Server Oracle
Activity:  1742 views;  last activity : 02 16 2011 15:42:29 +0000
Which one is more better & secure ?
  
Share
 
 
  Rate : 
 
 
SQL Server Vs Oracle
6
 
 
 
 
27
5
12
Support   Support
Top Argument
2
3

My view is SQL Server is important than Oracle because oracle users is very few in context with SQL Server.We manage large length of data with SQL Server.It is less worth than Oracle .Here we do any thing Update,Remove,Insert & many more directly like trigger fire ,Procedure programming . I think it is also support Oracle .Oracle manages SQL as Database.So it is clear that SQL Server is more important than Oracle 

 
By Mamta Sinha, Database Architect/Designer, Eurus  03 25 2009 03:27:30 +0000
 
Top Argument
6
0

As per my experiance i believe Oracle is better than MS SQL server. One point i have to mention here is,once we remove the data from MS SQL server, then we don't have any option to retrive the deleted record but in Oracle we can rollback.

 
By Dinkar Divakaran, Lead IT Analyst, Monsanto  03 26 2009 10:53:52 +0000
Arguments in: "SQL Server vs Oracle"
0
0

Well oracle is quite heavy as in comparison to MS Sql


By Rajeev Sati, Trainee A/C , Ministry of Finance  | 06 20 2010 12:41:46 +0000
0
1

sql
By Ashwani , Software Developer, 7webOceans  | 04 08 2009 13:14:30 +0000
2
0

Microsoft has newer technology and some great programs to offer. There is more flexibility and you can use any other programs with it. I think the new versions of sql server will suceed and become the favorite.
By Randi Adler, CEO LVWebCreations  | 03 25 2009 10:35:40 +0000
0
0
I've found that SQL Server is much better at getting up and running and building apps quickly. Oracle is just too complicated for normal people to be able to pick up a book and a CD and start coding within any reasonable time.
By Raji S, Business Analyst, SAP  | 08 16 2008 01:12:52 +0000
0
0
Excellent performance for almost in critical condition can trice to well
By JAGADEESAN S, Project Leader/Managing Consultant, Project Consultant  | 02 16 2011 15:42:28 +0000
0
0
ORACLE is the unparalleled RDBMS known for its robustness and stability in comparison to any other RDBMSs known. SQL Server has several short-comings, may be good in Microsoft platform, a lot of gaps if run in other platforms!
By S. Muralidharan, Executive Director, Knowledge Foundation & Campus Around the Corner  | 02 16 2011 14:53:05 +0000
0
0

dear mamta singh

a good object's worth is not calcuted by it's but by it's functionalitys

by the way oracle is able to manage hundreds of gbs of data with better management functionalitys for warehouseing and mining of data

 

f.y.i the client base of oracle is far wider then ms sql server
By abhishek sakhapariua, B.Tech/B.E. student, VVP Engg. College  | 02 16 2011 13:45:35 +0000
0
0

see the below link

http://it.toolbox.com/blogs/parthas/scalability-sql-server-vs-oracle-11064
By prashant pamani, Project Leader -(Technical), Sunbelt Outsourcing Pvt Ltd  | 11 02 2010 13:51:05 +0000
0
0

MS SQL Server has its origin from another database product called Sybase. Sybase was popular once upon a time. It is difficult to compare Oracle and SQL Server, Oracle is way ahead in terms of features and its design. MS SQL Server is the best provided you use it with MS products like asp.net, c# etc. Also, if you are new to databases, I think MS SQL Server is easier to understand (i could be wrong). Anyway, Oracle is still the king among database products.
By John Jacob, Consultant, confidential  | 10 01 2010 15:52:43 +0000
0
0

Oracle is better than Sql server in all aspect.
By Sharad Gupta, Software Developer, Tripura Technologies, Hyderabad  | 10 01 2010 11:03:57 +0000
0
0
if you have full recovery then u can.
By nilabja , support engineer, Microsoft  | 04 04 2010 14:24:10 +0000
0
0

No match for oracle databases.
By Khalid Mehmood Awan, asdfasf, asdfasfsdf  | 07 13 2009 03:52:23 +0000
0
0

Darpan you are absolutely right that oracle is much better than SQL server and just to add on to what you said, below are the advantages that oracle has:

  • Oracle 9i Database supports all known platforms, not only the Windows-based platforms.
  • PL/SQL is more powerful language than T-SQL.
  • More fine-tuning to the configuration can be done via start-up parameters.
    •

By Dipen Trivedi, Project Manager, 3i Infotech  | 04 02 2009 07:10:03 +0000
4
0

Mamta I dont know where you find this.. how ever just to state that sql server is a ok tool if you have low budget and low data if your data size is big then using sql server can be a big pain.

Lot's and lots of cons with ms-sql server .. however oracle rocks :) eg.

In sql server --cant use Arrays

In Sql Server cant use dynamic queries with functions

In Sql server cant call sp from a function
By Darpan Sinha, Tech Architect, Royal Bank of Scotland  | 03 27 2009 07:54:30 +0000
2
0

Oracle is Oracle SQL Sever is SQL Server it all depends on what you are trying to achieve if you are programming the application using Microsoft technologies (OS and App) then SQL Server is the best as it provides m uch better integration with the application but if you are coding on the other technologies then Oracle is the best.

I find sql server more complicated as there is a lot of supporting technologies embedded, and integrated with a lot of related components. so at any point of time i would prefer Oracle as a database;
By sandeep s, Consultant Database, Microland  | 08 29 2008 06:35:28 +0000
Argue for "SQL Server"
Argue for "Oracle"
 Found the debate "SQL Server vs Oracle"  interesting ?  Suggest to your connections and communities  
Post Your Resume Now !
  • Create a confidential Career Profile and Resume/C.V. online
  • Get advice for planning their career and for marketing of experience and skills
  • Maximize awareness of and access to the best career opportunities
Viewers also viewed
Dynamic Management Views   The dynamic management views (DMV’s) in SQL Server 2005 are designed...
 
11 referals 6 comments, 1828 views
Though media vs Self
 
157 referals 105 arguments, 3005 views
more...  
Recent Knowledge (5)
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
more...  
Sponsored Jobs
More From Author
http://toostep.com/debate/is-technology-always-safe I guess a lot has been discussed there too.. Technology is never bad its all about our perceptions..
Actually not but companies have certain policies to follow. You can't go to 11th std without passing 10th. Its like that if you give job to a guy who has a backlog he will not finish his degree since he is working.... Thats why companies ask for a...
YouTube has come to define the era of online video, so let's take a look at its most popular videos of all time. Our latest update has Justin Bieber still at number 1 with Baby, which has become the first YouTube video to pass 400 million views....
more...  
  • Popular Knowledge
  •  
  •  
  • Popular Jobs
  •