3 ms·

It's hard for me personally to imagine a 30-minute update query that is not written extremely inefficiently, or else a one-time huge data migration. There are

It's hard for me personally to imagine a 30-minute update query that is not written extremely inefficiently, or else a one-time huge data migration. There are a lot of the former in the wild to be sure. I've had a lot of run turning minutes-hours into milliseconds. :)

londons_explore 3y ago
Data scientists... And when you look at the query, it'll be 800 lines of SQL...
- hobs 3y ago
  Heh, that's not so bad - 2 jobs ago I had to fix a KPI generation process that was 70k lines of dynamic sql, that unwrapped to up to 1m LOC :)
  - chaz6 3y ago
    Did you ever run into a hard limit of statement size?
    - hobs 3y ago
      No, but all the code generation was happening in the server itself so I dont know how hard and fast it applies, iirc SQL Server's limits are like 64k x packet size.