SQL Server install disk. Just choose the option for "Client Tools Only".

Inline UDFs, like views, can be great if you use them properly. If you deviate even slightly from "optimum" use, they can kill performance very, very efficiently.

The key to...

Shouldn't. Have an undo script that reapplies the permission if something blows up.

This is a duplicate thread. Please don't post the same question in multiple places on the site.

Load and space would be the main things.

You'll have to re-create it. I set them to do that in an auto-start proc that fires off when the SQL service starts.

You might need to reinstall BIDS. That and Visual Studio share a lot of resources.

Bulk imports usually disable triggers. I don't think there's an option to bypass that in the Import Wizard (could be wrong, take a look for something like that).

If not,...

RedGate and ApexSQL also both sell software that's designed to help document SQL databases. I think you can get free trials from both. You might try those. ...

Add an output parameter to the stored proc, assign it the value of @@Rowcount after the insert statement, and grab the value of the output in SSIS. SSIS's Execute...

It's probably that you're getting "join multiplication". How many rows does the table you're updating actually have that fit the Where and Join criteria?

I've gotten that error a few times. It usually means either the Excel file is open (me or another user), or that the account SQL is running under doesn't...

If it's the same code, the performance will probably be the same.

The only way to know for sure would be for you to set up a test and try it...

mtucker (7/30/2009)

---

Lynn, a logical fallacy is a logical fallacy regardless of what you believe. You can believe 1+1=3 as much as you like, but it is incorrect. Circular reasoning is...

Those of us who believe do so on Faith. It guides us, and strengthens us. It helps us through the darkest times of lifes, and provides peace during the good...