As much as hat would kill the network, I haven't seen any other solutions to the problem.  If what was originally proposed is indeed the requirement then.

a: Enough free space...

Are you sure this is a problem.  Sqlserver will grab memory when it needs it and very rarely gives back to OS (unless requested to do so).  At server start it...

Are you sure it's empty.  I've seen it where you have to use the scroll bars on the screen to find the objects.

Let us know.

Tom

If the database is running with a domain account and there is space on another server somewhere, you can setup a backup device to a unc path.  You will then be...

Anytime that I have done Sql backups to tape, I use the format option with the first database I backup to that tape and the noinit option with any others...

If your not using the log file for recovery puposes than I would put the database into the simple recovery model and not worry about it.

If you need full recovery: ...

An index is sorted, a constraint is not.  Both will have statistics.  Index will be used for data lookup.

Tom

On top of the index analysis, I would look at changing the order of the exists clause and put the bigger tables to the top of the statement. 

set statistics...

From looking at the statistics, the problem seems to be with:

Table 'tripacc'. Scan cnt 451, logical reads 17378386, physical reads 0, read-ahead reads 48

That's alot of logical reads on that...

I would run this with the statistics io on.  This will give you the number of scans happening on the tables.  My guess is that the address table is considerably...

A lot of times, for ddl changes, EM will drop and recreate the table.  That is why it takes such a long time to complete.  Run a trace on it...

I connect to db2/400.  I created an ODBC datasource to the db2, and then created my linked server to the odbc datasource.  Works great.

Tom

It's in the master.dbo.sysdatabases file.

Tom

We are doing something similar.  I'll customize the solution for you. 

Make a table (Security) that has 2 columns: username and division.

Then create a view that join your new Security...

When does the log file get backed up.  If this is happening in a maintenance job and you have shrinkdatabase also turned on, it is possible that the log file...