thanks for the comments guys, my biggest concern is more focused towards the new features that haven't been proven yet and i can't help but worry that they may still...

could be VAS related, have a look at this[/url], may give an indication.....

what is the process thats running? I've seen similar issues when running bcp / xp_cmdshell and when its killed the process itself doesn't get killed and SQL Server will report...

hence why i posted the link on how to calculate it

could you post the execution plans for both so we can determine whether it is in fact an implicit conversion issue?

have a look at this link, should help you calculate the size required.

IIRC, as a general rule of thumb the page file should be 1.5x size of the ram...

Have you installed a CU/SP? Has anything changed with the service account or where the agent logs are written to?

Have you tried simply restarting the service?

someone else may be able to clarify this but i think swapping the indexes may in fact invalidate support from Microsoft..........

If performance of this table is an issue i'd look...

Can you post an execution plan? I'd be inclined to say the first port of call should be your Where clause. Using ISNULL and case statements can cause index...

I agree with Perry Whittle, this issue is likely to happen again and again if you try and fudge it.

Short term fix is to get the database moved (or...

Can you elaborate on this? In my experience high...

Sorry saga but there are books dedicated to the questions you've asked above so therefore far too much information to relay in a forum post.

As Jeff has suggested have...

a method i've always used and works for me is this:

with t (rn, col1, col2) as

(

select

rn= row_number() over (partition by col1, col2, etc order by col1, col2, etc),

col1, col2, etc

from...

depending on how far you want to go with this (and what you truely want out of it) then it may be worth investing in some 3rd party software from...

Yea I've spoke to steve and mentioned it to the webmaster this morning (gmt), just awaiting it to be updated. The script is there in script manager format and is...