Using SQL Server’s Parameter Embedding Optimisation

In this post I’m taking a look at the Parameter Embedding Optimisation that can be used by the SQL Server query optimiser when statement level recompilation is used.

This can be taken advantage of, for example, when implementing dynamic filtering or dynamic sorting, i.e. when user input determines which columns of a table […] “Using SQL Server’s Parameter Embedding Optimisation”

Finding the Column Name of an SSIS Error Output Error Column ID

Many SSIS data flow components have error outputs for optionally directing rows through, e.g. for handling data type conversion errors.

These error outputs include the data columns being handled by the component, as well as 2 additional columns – an ErrorCode column and an ErrorColumn […] “Finding the Column Name of an SSIS Error Output Error Column ID”