Viewing 15 posts - 13,591 through 13,605 (of 22,227 total)
Do you have some sort of monitoring software? That looks like some sort of standard maintenance script. Check for scheduled jobs or monitoring software.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 17, 2011 at 8:46 am
Ninja's_RGR'us (1/17/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 17, 2011 at 6:18 am
pdanes2 (1/14/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 14, 2011 at 12:46 pm
homebrew01 (1/14/2011)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 14, 2011 at 9:30 am
I would be very, very, very careful about using NOLOCK. It seems like it solves problems, but it can introduce bad data. By that I mean, repeated rows, missed rows,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 14, 2011 at 9:24 am
Viewing 15 posts - 13,591 through 13,605 (of 22,227 total)