3 ms·
I don't have the experience to compare them to Oracle, but SQL Server and Postgres do have their own issues. The infamous MSSQL "string or binary data will be
by yyyk 5y ago
I don't have the experience to compare them to Oracle, but SQL Server and Postgres do have their own issues.
The infamous MSSQL "string or binary data will be truncated" error (fixed a while ago[0]), or the way either deals with unqualified access to columns which leads to surprises (e.g. in MSSQL subqueries or in Postgres's SECURITY DEFINER procedures).
[0]
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-traceon-trace-flags-transact-sql?view=sql-server-ver15#tf460 https://docs.microsoft.com/en-us/sql/t-sql/database-console-...
- tomrod 5y agoOh indeed, they all have quirks. Oracle seems to have more than most, IMO. I have a journeyman data engineering level experience with each. Rare combo I guess, Data Scientist focus.