Query name	VarChar Null and Empty Overlap
Server Asset Type	Job, Shared Container
Analysis Type	Advisory
Description	Identifies Server Jobs differentiating between Null and empty strings which is not easily achievable in the Parallel engine without JOb modifications.

Issue

Your Server Job uses features which differentiate Null and empty string but which are not available in the Parallel engine. You can find a deeper explanation at Differences between Server and Parallel VarChar.

Actions

This is an advisory Asset Query only, but you may choose to modify your Job(s) to use Parallel-native features and functions to achieve the differentiation you require.

VarChar Null and Empty Overlap

Issue

Actions