That's probably not going to do what you want. You are trying to build a concurrency model. You need to determine if the field has changed since you...

I would put that method of sending data to your database into the "bad idea" bucket. You should try to talk your front-end guys into doing this in a...

That would not be an equivalent query.

Of course if you write one of them wrong, they will get different execution plans.

As far as performance. The optimization engine will generate the same execution plan for equivalent queries regardless of which syntax you use.

You can do an outer join with your join information in the where clause.

However, use the JOIN keyword. The old syntax with tables spearated by commas and the join...

There is no automatic built-in way.

You have a number being transferred into a field that is too small. Something like trying to put a BIGINT into an INT field. It will probably be...

Returning results from a query in SSIS and putting them into variables is pretty simple, so either your description was not great, or you missed something a bit obvious.

1) Use...

It is quite the indexing question actually.

If you have 26 bit fields you could index each field individually (which is somewhat useless) or index groups of columns in which you...

In package configurations, you have an option to set a value based on a parent package variable. So, if you use your parent package's config file to get the...

Do you have automatic statistics updating turned off?

SSIS is not going to be happy with you plan.

Even though your SQL Statement is a "SELECT *", SSIS gets the meta-data and stores it in the input and output...

It will not get the huge data set and then filter it down. The database engine will optimize that in the same way it would optimize using a sub-query.

My...

Make sure you look up the startup paremeters in BOL and come up with an appropriate value.

Setting the startup parameters is one of the options that MS made hard to...

You will have to deal with this in a couple of parts. Using the OUTPUT caluse of your insert into your parent table logging table will get you the...