The most important difference is that SQL Server has everything that Oracle has to offer at a much, much cheaper price.
I agree that comparison with postgres and mysql are pointless. They offer a tiny fraction of what enteprise products have. If you need it, you will know.
One thing that comes to mind is Linux (or Solaris, HP-UX, or other nixes) support. SQL Server is essentially Windows-only.
[1] https://blogs.microsoft.com/blog/2016/03/07/announcing-sql-s...
https://technet.microsoft.com/en-us/library/ms184286(v=sql.1...
Oracle stores the old version of the row in a rollback segment.
According to the following article, "only changed values are written to undo whereas PostgreSQL/SQL Server creates a complete new tuple for modified row. This avoids bloat in the main heap segment." [1]
1. http://www.enterprisedb.com/postgres-plus-edb-blog/amit-kapi...
Both Oracle and SQL Server has some way to restrict the growth of version information whereas PostgreSQL/PPAS doesn't have any way.
(Don't speak to me about SQL Server. Of all the brain dead ideas, implementing storage in the TempDB for snapshot isolation!)
Once they get the shoulder in the door, they push to expand the database horizontally in the organization.
Microsoft has a similar strategy with CRM and SQL Server. SQL Server drives their corporate success.
Postgres vs. Oracle, etc is a pointless argument because it's answering the wrong question.