Difference

SeoDezin · #1 (**permalink**) 11-26-2011, 06:31 PM

What is difference between SQL Server and Oracle?

addyj672 · #2 (**permalink**) 11-27-2011, 10:00 AM

Both are database software and very much related to database. One is Microsoft and second is oracle product....

deveshraigniit · #3 (**permalink**) 11-29-2011, 12:01 PM

The FIRST biggest difference: Transaction control. In Oracle EVERYTHING is a transaction and it is not permanent until you COMMIT. In SQL Server, there is (by default) no transaction control. An error half way through a stored procedure WILL NOT ROLLBACK the DDL in previous steps.

The SECOND biggest difference: MVCC. In SQL Server and Oracle is different. SQL Server will allow dirty reads, and writes can block reads in MS SQL (Again, it's configurable but the default in SQL Server is for performance and not read consistency, unlike Oracle where read consistency is default and unbendable.