Viewing 15 posts - 31 through 45 (of 178 total)
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...
September 27, 2011 at 12:38 pm
August 23, 2011 at 2:02 am
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...
August 17, 2011 at 1:45 am
hence why i posted the link on how to calculate it
August 16, 2011 at 9:00 am
could you post the execution plans for both so we can determine whether it is in fact an implicit conversion issue?
August 16, 2011 at 1:53 am
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...
August 16, 2011 at 1:39 am
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?
August 15, 2011 at 1:39 am
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...
August 15, 2011 at 1:35 am
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...
August 15, 2011 at 1:32 am
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...
August 15, 2011 at 1:15 am
Ninja's_RGR'us (8/11/2011)
The only thing of value I can add here is tha cxpackets is not a problem and not a real wait.
Can you elaborate on this? In my experience high...
August 15, 2011 at 1:05 am
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...
August 11, 2011 at 3:13 am
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...
August 11, 2011 at 2:54 am
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...
August 11, 2011 at 2:41 am
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...
August 9, 2011 at 2:06 pm
Viewing 15 posts - 31 through 45 (of 178 total)