|
|
|
|
|
|
by briffle
2031 days ago
|
|
|
I came from Oracle, not SQL Server, but the largest benefit to me, is at a previous job, I ran Oracle Standard (that cost About $25k for our 2 core servers) and one of the critical limitations is you can't build an index without locking the table. The ability to do it 'online' was an enterprise only feature (that would have cost about $700k on our hardware), so we were unable to do any index changes on our tables, since it would take 10-12 hours to rebuild some key tables, and we couldn't block all our transactions for that long. SQL server also makes that an enterprise only feature. PostgreSQL has the native ability to do that. There are lots of other benefits, but that is the first that comes to mind. When they come out with Babelfish for Oracle, then stuff is going to get crazy. EnterpriseDB has some limits to its functionality, and its cost is pretty high. |
|
|