Viewing 15 posts - 13,576 through 13,590 (of 22,213 total)
I agree. Execution time is one of the most important. Not on your list is one of my other favorites, frequency of call. Your longest running proc may be called...
January 17, 2011 at 11:58 am
Do you have some sort of monitoring software? That looks like some sort of standard maintenance script. Check for scheduled jobs or monitoring software.
January 17, 2011 at 11:50 am
GilaMonster (1/17/2011)
Koen (da-zero) (1/17/2011)
GilaMonster (1/17/2011)
Was one of the things that contributed to me leaving the bank. The over-paid consultants from Big Named Consulting Company were considered (by upper management) to...
January 17, 2011 at 10:54 am
GilaMonster (1/17/2011)
pdanes2 (1/17/2011)
"It doesn't work" gets little sympathy in these forums
No, because it's near-impossible to offer useful advice for that. When we have some indication what's not working, that's a...
January 17, 2011 at 8:47 am
Koen (da-zero) (1/17/2011)
GilaMonster (1/17/2011)
Was one of the things that contributed to me leaving the bank. The over-paid consultants from Big Named Consulting Company were considered (by upper management) to know...
January 17, 2011 at 8:46 am
Ninja's_RGR'us (1/17/2011)
January 17, 2011 at 7:09 am
LutzM (1/16/2011)
Lynn Pettis (1/16/2011)
And then you have those individuals that won't even ask their DBAs for help because they don't know them personally and are in a different building.
Strange he...
January 17, 2011 at 7:00 am
In the merge operation against MalWare, why are you doing this in the select from the temp table:
group by (FullURL + [MalwareGroup]), FullURL, [MalwareGroup]
If you're going to all the trouble...
January 17, 2011 at 6:55 am
I looked back through the thread here, but I'm not sure I saw it. What is the recovery setting on the database? Is it set to Full Recovery? If so,...
January 17, 2011 at 6:18 am
pdanes2 (1/14/2011)
January 17, 2011 at 6:13 am
To see if a resource is locked, you do have to query the server. To see if a lock is blocking another user, again, you have to query the server....
January 14, 2011 at 12:46 pm
homebrew01 (1/14/2011)
January 14, 2011 at 12:38 pm
pdanes2 (1/14/2011)
Grant Fritchey (1/14/2011)
I would be very, very, very careful about using NOLOCK. It seems like it solves problems, but it can introduce bad data.
Hmm, yes, I see what you...
January 14, 2011 at 10:58 am
zerolan22 (1/14/2011)
I used the 2 bigints as a combined, primary clusered index with no performance improvements, rather the opposite, it was even slower on
inserts....
January 14, 2011 at 10:30 am
I haven't looked at the exec plan, but first off, get a clustered index on the table. Absolutely. Figure out what the right place to put it would be and...
January 14, 2011 at 9:30 am
Viewing 15 posts - 13,576 through 13,590 (of 22,213 total)