Viewing 15 posts - 13,591 through 13,605 (of 22,224 total)
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
Yep, I've done it. It can work great. It requires a lot of discipline, but you can do it. I've written a couple[/url] of articles[/url] on it (although they're 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 14, 2011 at 7:58 am
It sounds like it could be contention, probably blocking, from uncommitted transactions. While you're in that stuck position, run this little query:
SELECT der.blocking_session_id,
...
"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 7:49 am
Gotta be a difference in the stats. Should be evident by having different execution plans.
"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 7:44 am
Viewing 15 posts - 13,591 through 13,605 (of 22,224 total)