I'll through my 2 cents in as well. If the OP had posted what they had come up with, I would correct the errors gladly. When you ask...

But wouldn't the insert have an exclusive lock on the new row created until the end of the transaction and the update, without a where clause would need an exclusive...

One hint I picked up somewhere, and to be honest I did not test it, is to use code like this to get a consistent query plan:

Select

...

I don't have sql on my laptop so I could not look and I haven't done that in a while.

You could also right click on the database - all...

Darn, you beat me by seconds!:crying:

In SSMS you can right-click the table and and use script as create and it includes all the contraints, indexes, etc...

A couple of things. I would think that it would cause a deadlock since the insert is taking an exclusive lock which should block the update. The second...

Is IIS starting? Is the reporting service on the same server as sql server?

You could use the information_schema.columns to get the size of the columns, sum it, and multiply it by the Count of the rows for that customer.

That should give you a...

It sounds like the query is run first/more often with the unrestricted results and that the cached plan is using a table scan. So you will not get the...

Are the indexes on the same file as the table? What is your physical setup? Is the server clustered?

Are you sure the linked server user has appropriate permissions on the table in question?

Make sure recursive triggers is off, sp_dboption 'recursive triggers' and in a trigger on table2 do:

Insert Into table2

Select

...

10 days BEFORE today or 10 days AFTER today, PAST or FUTURE?

Since this is a school assignment I will just give a hint. In SQL Server dates work just...

Actually Jeff, I did not mean to imply that there was a dates table. The OP did not post any table or column names so I just used dates...