Thanks Eugene, I just tried your test method and confirmed that this method is SARGable:

WHERE MyNullableCol IS NOT NULL AND MyNullableCol != ''

so there are clearly situations where it is...

Luis mentioned that in a WHERE clause, something like the following would be non-SARGable:

WHERE ISNULL(MyNullableCol,'') != ''

Is that non-SARGable purely because it contains a function (in this case the ISNULL()...

Don't forget that whenever you ever move the package to another server it will fail again until you or a colleague finds out about the registry hack. Ultimately that...

I had a similar issue in SSIS 2008 with an Excel file that had columns wider than 255 characters, as well as embedded text qualifiers and delimiters. A real...

Special XML characters in the delimited string can easily make it fail, even a single & or < will prevent this function working. You would probably have to put...

I think I had that error a while ago. I got the impression that somehow the .dtsx file had simply got corrupt. I started again with a fresh...

Is the code for the view in the "// Join Criteria" section of this article all messed up, or is it just me? There seem to be lots of...