Execution plans so we can understand which indexes are used, not used, etc., would be very helpful.

The only thing I'd add to the "must have" list is:

a method for monitoring performance

a process for updating structures/code/procedures based on...

How many rows are in the table and how wide are they? If the data can fit on only a few pages, you're probably looking at maximum defrag now.

I'd have to see an execution plan for the good execution and one from the bad execution to even make a guess as to what's going on.

As to the locking,...

You'll get the joins between tables because of the referential integrity checks that are a necessary part of any delete. However, putting an index on a column like DeleteId will...

The principal difference between the two is that the inline table valued function can be built with a parameter where a view cannot. Most of the time, but not all...

It sounds like you're debating normalized vs. denormalized data.

For very simple select statements that don't involve much in the way of filtering, but simply pull data based on a key...

No kidding, drop the grenade & run...

They could be doing something silly with reseed?

I'm running it side-by-side with 2005. One of my co-workers has 2000, 2005, and 2008 all running on his personal machine with no issues from any of them. The same...

Maybe something like this (untested since you don't have structures posted):

SELECT T_OrderHeader.OrderID,T_OrderHeader.CustomerID,T_OrderHeader.ShipTitle, T_OrderHeader.ShipForename,T_OrderHeader.ShipSurname,

CONVERT(NVARCHAR(20), T_OrderHeader.OrderDate,...

It's hard to tell you explicitly what happened without the data and structures, but you seem to have a data issue: "Error converting data type varchar to numeric". That means...

The secret to dancing is to not giving a flying rat's patootie what you look like while dancing. No, it won't make you dance better, but you'll have more fun....

I work for a larger company. We don't spend a lot per person and nothing like 5%, that would be great. However, they do have tuition reimbursement and the boss...

That's where I was trying to get with the do vs. juisu. Look at an Iaido practioner and then an Iaijuitsu practictioner. The difference is huge, although, to a degree,...

Personally, I'd use BIDS, but that has a bit of a learning curve to it. You might want to start with the wizard to see if it will do what...