I just assumed that when I asked for a 2008 database that is what I got. -- It should be easily changed.

As for the deadlocks -- I am now running...

Thanks, you answered my question 😉

I think that is the issue -- it is set to SQL SERVER 2000 (80)

Should I change it to SQL SERVER 2008 (100)?

TF

I did not install the server --- it...

Lutz,

I tried running the script by Jesse. Keeping in mind we are using SQL 2008

When I run the code against the master db - it says it creates the...

So when you are going through this process do you basically pick apart each individual query and come up with an indexing strategy for that particular query?

It sounds like each...

You were right -- I looked at the wrong index.

Here is the updated plan after I made your suggested change

TF

Just a second followup --

I tried to include the columns you suggested. It turns out there were already in excess of 10 columns included.

The columns currently included...

Thanks Lutz -- I will try that.

A couple of quick questions (since I am new at this):

1. How did you review the plan and come up with that recommendation? ...

Here you go

TF

Lutz,

Here is the plan. Right now the DB is empty as I am just queing another test....I am not sure if the plan will change once the dat ais...

Lutz,

A couple of quick answers before I get to posting the plan...

- I do not think it is a query optimization problem. The query runs relatively fast in...

is this what you mean?

SET TRANSACTION ISOLATION LEVEL SNAPSHOT

BEGIN TRAN

UPDATE Invoiceheader set......

Commit Tran

If so -- no I have not tried it.

Do I need to do the same for the read...

Just a side note -- the invoiceheader table has 16 indexes defined on it.....

Most of them generated by running the sql profiler and accepting its' recommendations.

Not sure if that helps...

TF