4 ms·

What in particular do you miss from other SQL languages?

• manigandham 11y ago
  UPSERT (or similar logic, not merge).
  • jklowden 11y ago
    Oh, then that's your problem. MERGE is standard, and has clear semantics. UPSERT is nonstandard, and semantics vary among implementations. Microsoft doesn't need to make SQL Server look like MySQL. Quite the other way around.
    • techdragon 11y ago
      There's not really a standard anymore for UPSERT to be added to. SQL has fragmented and since the last few iterations of the standard allowed for "additional non standard features", adding an UPSERT is perfectly compliant with the SQL standards.
    • manigandham 11y ago
      UPSERT should be a standard, why isn't it? And it's very useful in a ton of situations which is why so many other SQL dialects have added it. It's not like SQL Server is completely standards compliant so I'd rather have the functionality then have to use MERGE because it's "standard".
• tyfon 11y ago
  Date handling, simple things like postgres date_trunc('month', now()) and especially looping over records in stored procedures without using cursors (that are prone to crashes). I work with both on a daily basis and there is a mile of difference. Yes I can accomplish whatever I want in sql server but there are so many small things that could improve. Some of other pet peevees are: You can't use a lot of left joins, it slows down the query dramatically. If there is only one to one relation, use subselects instead. Thou shall not do queries like this: select foo into baz from bar where fooid not in (select fooid from bar) They are the death of the engine. And many "unwritten rules" like that. Postgres just accepts the queries and run them..
  • us0r 11y ago
    SELECT DATEPART(month,GETUTCDATE()) ? Either you are using a very old version or not using SQL Server at all cause I pretty much do everything you are complaining about on a daily basis and on a very large set of data.
    • tyfon 11y ago
      Your query only extracts the month integer from a date, it does not floor it to the month. The equivalent for sql server is this ugly thing: select dateadd(month,datediff(month,0,getdate()),0) We are on SQL server 2014. I have had a query go from 2-3 hours down to 7 minutes by replacing left joins with subselects within the query for instance (and yes all the indices are in place as recommended by sql server query planer) The one with a insert based on a query on the same table I have never managed to run at all and I have to use a temporary table as an intermediary instead.
      • Lozzer 11y ago
        The last one might be heped by trace flag 4199. You can apply it to individual queries with option (querytraceon 4199): https://blogs.msdn.microsoft.com/psssql/2010/09/01/slow-query-performance-because-inaccurate-cardinality-estimate-when-using-anti-semi-join-following-upgrade-from-sql-server-2000/ https://blogs.msdn.microsoft.com/psssql/2010/09/01/slow-quer...
      • advocato 11y ago
        I have seen Sql server query planer do stupid shit too. Almost always Statistics where to blame. Are you sure those where up to date? For some reason the "auto update statistics" functionality doesn't seem to work reliably, you have to update them in a maintenance job to fix this.
  • deleted 11y ago
    [deleted]