Normal 0 false false false EN-US X-NONE X-NONE First and Foremost: What Is Parameter Sniffing? When a stored procedure is executed the first time the query analyzer compiles the stored procedure and creates an execution plan. This part of this involves looking at the parameters to see how they are used and optimizing the execution plan. This plan is then cached and used in subsequent runs of the stored procedure. The issue here is what if you pass in a parameter that brings back 10 records on th...
Read More
Normal 0 false false false EN-US X-NONE X-NONE CTEs are a great thing to use in your query. They are an excellent way to consolidate code and make it readable as well as create a “view” inside of your code. One great thing I have used them for many times was to pick out the max date associated with a set of key values. So let’s say there is a table that has a column called ID, Quantity and Date. And in this table there are duplicate IDs with different quantities and dates associated with them. S...
Normal 0 false false false EN-US X-NONE X-NONE There is an issue with script tasks in SSIS 2005 that could come up occasionally. It is generally an issue that shows up in a 64-bit environment where the script can’t be pre-compiled. The error that will show up states that “The task is configured to pre-compile the script, but binary code is not found.” There is not a fix for this inside SSIS as you can’t set the script to Pre-compile false as the error will just change to the script can’t be comp...