Page Faults demonstrate that a lot of page swaping is going on and points to potential insufficent memory. If all other figures are low but the Page Faults are high...

I never thought about the index hint ordering. I will say that is cool and does work nicely.

Try changing your trigger to match the updated syntax for joins to see what happens.

CREATE TRIGGER rem_trg_rem_Test_table1_INSERT ON rem_Test_table1 FOR INSERT AS



SELECT INSERTED.[ID] FROM INSERTED...

quote:

---

These no's are far below than ours :O.

At 446112K of memory consumption by SQLSERVR.EXE, page faults are 114665K.

We have upgraded our...

I am not 100% sure and have not found the details anywhere but I believ stolen referres to there not being enough buffer space for all processes and that another...

Are the columns in order via a clustered index so that the order is currently 4,6,8,9

if so then the previous should handle otherwise i say is 8,6,4,9 8 will be...

I will say I am not a fan of cursors for server side stuff just by the way they use memory as they are more intensive for the most part....

Did you install while logged in as an administrator account? Not Power User or other but Admin.

Look at the execution plan of the update that is causing the issue. It will of course lock rows/pages or table based on the plan and something may be dragging...

This will give you just the column names from the PK. It was stripped from the sp_pkeys Proc.

select

convert(sysname,c.name) as COLUMN_NAME

from

sysindexes i

INNER JOIN

syscolumns c

ON

c.id = i.id

where

(i.status &...

Sorry cafemar1 I wasn't meaning to make it sound otherwise.

This

quote:

---

SOAP Toolkit 3.0 uninstalled, 2.0SP1 installed, the 3.0 re-installed

---

never happend on my machine...

Can you capture both execution plans in text form and post so we can see the differences. I use them myself a lot and have gotten used to reading them....

Tested myself. Apparently there is a limitation within subqueries to cascade inward.

Testing myself it seems at level 3 it cannot see any of the alias before itself, even level...

quote:

---

so if you say

select distinct name, count(name)

from table

it won't work

you have to say

select distinct name, count(name)

from table

group by name

and it lists the...