Viewing 15 posts - 571 through 585 (of 1,129 total)
exactly ..thats what i wanted to know is it helpfull to have AUTO Update STats( as far as i know this will update stats on tables if more than 20%...
June 2, 2011 at 7:49 am
Ninja's_RGR'us (6/1/2011)
Leave it as is.If this hurts your server's performance during the stats update then you have a lot more to worry about than auto-stats updates.
Thanks i am...
June 1, 2011 at 11:25 am
here is the thing.Occasionally a select inside this sproc is hung.Now today i found the sql where it is hung using trace , when i run that sql manually from...
May 27, 2011 at 10:26 pm
arun_sql (5/23/2011)
im sure that there is a Server Memory Change event class (tick all events when in profiler)
Thanks. I selected that event as you said but didn't find anything logged...
May 23, 2011 at 2:45 pm
GilaMonster (5/23/2011)
sqldba_icon (5/23/2011)
May 23, 2011 at 12:14 pm
This job runs once everyday. I have nailed it down to a select statement which has the issue. So if i run this select first time, it will take 45...
May 23, 2011 at 11:50 am
Thanks everyone. The issue which i am trying to trouble shoot is not for an application but just for a long-running job. I do now where the issue is.But just...
May 23, 2011 at 11:31 am
LutzM (5/22/2011)
It might help to add a computed persisted column to get rid of the CASE expression...
May 22, 2011 at 6:27 pm
LutzM (5/22/2011)
At a first glance it looks like there's a missing index to support the t.rid = c.rid join (among...
May 22, 2011 at 4:47 pm
Nils Gustav Stråbø (5/22/2011)
sqldba_icon (5/21/2011)
In my case a CTE is using inside a proc, now where is this CTE stored? I thought memory? Isn't it?
I'm not sure I understand your...
May 22, 2011 at 8:06 am
send me your resume at sqldba.ahmed@gmail.com. We are looking for a junior dba.
May 21, 2011 at 8:27 pm
Ninja's_RGR'us (5/21/2011)
sqldba_icon (5/21/2011)
In my case a CTE is using inside a proc, now where is this CTE stored? I thought memory? Isn't it?
At proc creation time or proc / statement...
May 21, 2011 at 8:25 pm
In my case a CTE is using inside a proc, now where is this CTE stored? I thought memory? Isn't it?
May 21, 2011 at 7:14 pm
mister.magoo (5/20/2011)
sqldba_icon (5/20/2011)
Can someone please tell me where is a CTE stored when declared or used inside a proc? Is it stored in memory or hard disk?
I want to be...
May 20, 2011 at 10:54 am
Viewing 15 posts - 571 through 585 (of 1,129 total)