You main problem is in your second line: "My boss wrote a query". Bosses can bring down a hyperdome

Seriously though, I would rather...

Correct. Scans = bad. Seeks equal good.

A mention on the cost though: Everything has to add up to 100%. This means you need to get the best operations to have...

Yes it is. But you need the right access.

If SQL is running on your machine, how is it logging on? LocalSystem? Your username? If localsystem, no, it will not work.

If...

As Andras pointed out, if it is a clustered, it will probably use it. But using a non clustered and * will most likely never use it.

The reason being, to...

SSIS binds a component or task to a connection manager at design time and this cannot be changed at run-time.

If you have a package that is to be run on...

You want to look at SSIS configuration files.

There is a welth of knowledge on the net about it but basically, Menu > SSIS > Configurations.

In the wizard, you specify what...

What is the NT loging that SQL is using? i.e. the user account in the services. Let's assume it's SQLLogin.

If you logon to the server with that username, can you...

As per my first post - what vare the errors? What makes you think it should expand?

Let's face it, there are many many reasons why it would not auto grow....

"The tables are not that large" is a poor excuse.

Fair enough, you may find it easier but rather struggle to understand the right way to do it now than suddenly...

Will speaks wisely.

To add to his reason of SQL taking over, we had a serious issue a while back where SQL filled up one of the disks. This disk, amongst...

select

getdate(),

cast

(serverproperty('machinename') as varchar