Personally I think it is simply a self-serving fraud for software developers to call themselves engineers.

There is neither the scientific basis for the analysis, design, construction, and testing...

Hi Steve,

[1% of community]

Fair enough. Although I think few would complain if the solutions offered for consideration here _were_ scalable. At the very least - in my...

I am afraid this is not a practical approach for environments where the target database is large. Left outer join 50 million + rows for every import? Simply...

I found it. It's also called Advanced Query Tool (confusing isn't it). Here's the product web site. It does client side variable defintion and substitution and some...

With or without the go's, we need to be able to run only some of the statements at a time, in order to manually review the output and possibly...

Just as much hassle to repeatedly query a meta-data structure for the parameter values as it is to repeat the @variable definitions.

I am really surprised none of the third party...

Doesn't work because we run SQL statments manually to analyze results and sql messages.

This loses the variable context unless we continually repeat the @variable definitions and assignment of...

Hi Jeff,

Perhaps I wasn't clear, sorry. We do use query analyzer, and it does NOT support client side variable substitution (unless you want to count search and replace which...

Thanks Troy, I look forward to the implementation discussion.

In regards to modeling approaches, I am reminded of a well known quip from the famous American comedian Will Rogers....

Ok, I think I got it.

The "conceptual" level intentionally omits the distinguishing attributes for the subtypes. Those will be documented later in the "logical" model. Great!

Will your series...

Hi Troy,

Good series! I'd like to suggest that you include a bit more "real life" stucture to the model. Just enough to make the examples more "logically"...

Glad to see this effort! Too many sql programmers are way behind the curve in understanding conceptual and logical modeling and the theoretical basis that should be guiding such...

re. configurations.  I use them but carefully, otherwise they can be a real headache during development.  The gotcha with them is that once implemented, later changes to related objects in...

SSIS processing is ram memory intensive. I bet you are running out of ram, particularly as you are loading up the system trying to run multiple threads.  Check the memory...

if memory serves, the parser is not smart enough to understand SSIS parameter queries with the "?" place-holder.  The parser can only handle literal SQL.