@mark-3, your professional response is commendable. Thanks and good luck on your book!

LOL. Thanks for the easy point!!!

Gartner's research will give you some idea on BI solutions and their place in the industry.

http://www.gartner.com/technology/reprints.do?id=1-196WFCB&ct=120207&st=sb

I usually struggle w/ improving queries involving parallelism. Some dbas I've worked with recommended MAXDOP hint.

Even with those recommendations, I notice my queries some time don't use all available CPUs....

Try some of these options.

Option A:

- Use bcp to import data (after dropping all keys/constraints etc)

- Recreate all the keys/constrains after the data load

- Run the validation routine in SSIS...

Based on your description update-join seems close to what you want to accomplish. Lookup update-join. Ben Nadel has few good articles on it.

1. Create a table which will contain per record set: simple sql query with aliases, destination path including file name where flat file needs to be placed.

2.a. Create SSIS package...

If I have the option then I'd stick with tools that I'm familiar with. SSRS does a decent job with reports. I have been impressed with it's continuous growth.

Here are...

I have answer to my own question. The other package is also called via command line. Please consider this issue resolved.

I saw the same error if you had syntax error in the script component. I'll treat this like a generic error applicable to many unrelated issues unless some one clarifies...

The article covers the diagram feature well. I got an email with the subject line "Database Modeling and Diagrams with SQL Server 2008". It led me to think this article...

try this

SELECT

SUBSTRING(st.text, (qs.statement_start_offset/2)+1,

((CASE qs.statement_end_offset

WHEN -1 THEN...

Grant,

Good point.

I tried your query suggestion.

What's a good way to tie the cached query with the user? I can see the time it was executed and other statistics information related...

In his situation what is a good way to address this? I'm inclined to suggest that he restores from a backup containing the missing data. Once that step is done,...

add the error, your temp table script, insert script, and anything else that gives everyone a clear picture