Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server VS Oracle [closed]

I'm studying SQL Server but don't know much about Oracle. Can anyone give me a fair comparison of them? I've read a comparison about SQL Server 2000 vs Oracle 9i, but it's a little out of date. Have SQL server 2008 caught up Oracle 11g/i yet?

like image 766
Quan Mai Avatar asked Mar 27 '09 13:03

Quan Mai


People also ask

Is SQL Server better than Oracle?

In short, both Oracle and SQL Server are powerful RDBMS options. Although there are a number of differences in how they work “under the hood,” they can both be used in roughly equivalent ways. Neither is objectively better than the other, but some situations may be more favorable to a particular choice.

Is SQL Server faster than Oracle?

SQL Server is a good option if speed and processing power are not your main concern. Even non-technical users can learn it faster than Oracle and it has most of the features of other traditional RDBMSs. Either way, both databases are assets for your business and will help manage your customers and employees in tandem.

What is difference between Oracle Server and SQL Server?

KEY DIFFERENCEOracle allows rollback during the transaction process whereas SQL server doesn't allow rollback in the transaction process. Oracle supports many “Schemas” with the instance whereas SQL server offers “Schemas” within each user database.

Is Oracle SQL and SQL Server same?

No. Oracle Server is owned by Oracle. SQL Server is developed by Microsoft. Oracle uses PL/SQL.


2 Answers

Just my $0.02 after working with SqlServer for years and Oracle for 4 months now.

SqlServer is much easier to use, this allows you to concentrate on what you want the database to do (solve some business problems) instead of wrestling the server all the time.

Because Oracle makes you configure so many settings, there are a lot of ways to get them wrong. This leads to endless discussions about partitioning, the type of index to use, etc etc. During those discussions, nobody is thinking about the business problems.

An analogy: I once had a olympus camera with a good lens and some simple settings. I made nice pictures with it so I upgraded to a DSLR with all kinds of knobs and dials. With that my pictures weren't half as good because I was concentrating on the camera instead of the subject.

That to me is the difference between Sql and Oracle. Sql is easier to work with and therefore gets more things done. Ideas go from the whiteboard to working code so much faster. Only when you push for very large databases that Oracle might take the edge but I'm not even sure of that. I don't think there's something that Oracle could handle that SQL couldn't.

Edit: Also, Oracle is very poor at in-database analytics on large data volumes because of context switching to PL/SQL. So if you have a few complex functions you want to run on your data, don't use Oracle. MS SQL on the other hand shines in this area because it does not suffer from this issue and also has .Net integration.

like image 132
gjvdkamp Avatar answered Sep 28 '22 05:09

gjvdkamp


I'd say:

  • Oracle has a much better procedural language. T-SQL feels only half finished compared to PL/SQL.
  • SQL Server has a much better optimizer. When I used Oracle, I had to hint every query to make sure that it didn't take forever to finish, SQL Server just works. Might have been that the server was badly configured, though, which takes us to the next point
  • SQL server is a lot easier to work with. You need dedicated DBAs to administer Oracle, but pretty much any bozo can keep SQL server running.
  • Oracle has a better, more predictable and more well-documented concurrency model.
  • Oracle's documentation is superior in most ways.
  • SQL server integrates better with .NET (like the devil Linq2SQL).
  • If you use Oracle you also have to buy TOAD, but the included Manegement Studio will do for SQL Server.
  • Oracle has more cool but hardly necessary features like extensible indexing.

If I were to choose I'd go for SQL server because of the better optimizer. However, I don't really feel safe when multiple people use the same rows in SQL server.

like image 35
erikkallen Avatar answered Sep 28 '22 07:09

erikkallen