A company I worked for uses Syteline ERP which heavily relies on SQL Server. But the DBA was constantly complaining about how the Syteline SQL was. One major issue was long running transactions taking 10 minutes locking rows/tables for too long and using a lot of memory. You would think very expensive ERP systems would have decent SQL.