Viewing 15 posts - 17,236 through 17,250 (of 22,226 total)
Without knowing what your query is doing and what your structure looks like, it's just not possible to answer this question.
If you can, please post the query, the actual execution...
"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
June 11, 2009 at 8:26 am
Well, you can also see if a lock has an outstanding convert request inside sys.dm_tran_locks. That's an indication of lock escalation. Once the lock is escelated though, you won't see...
"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
June 11, 2009 at 8:23 am
I'd use a server-side trace. If you're unsure how to put them together, you can use Profiler to build the scripts for you after you use the GUI to define...
"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
June 11, 2009 at 6:52 am
I have to agree with Hans here. You may need to maintain logic in more than one location simply because you can't have a single solution for all problems. As...
"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
June 11, 2009 at 6:32 am
You're going to have to implement a code solution, not try to control locking. Here's a rough outline of an approach. You add two columns, call them InUse and UserID...
"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
June 11, 2009 at 6:28 am
WayneS (6/10/2009)
A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the likes of...
"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
June 11, 2009 at 6:20 am
t_king (6/11/2009)
"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
June 11, 2009 at 6:15 am
Based on the research and testing I've done with it, it's unlikely to cause much negative impact. It's also unlikely to cause much positive impact except in special circumstances. I'm...
"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
June 11, 2009 at 6:11 am
YSLGuru (6/10/2009)
"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
June 10, 2009 at 1:27 pm
RBarryYoung (6/10/2009)
"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
June 10, 2009 at 8:21 am
kladibeeto (6/10/2009)
Thank you for your effort I also find this on Microsoft site, but I am still not sure 🙂
How you can not be sure? Microsoft may be a large,...
"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
June 10, 2009 at 7:49 am
A dump is just a backup. They're EXACTLY the same thing. Dump is just old terminology. I wouldn't do it for them. I get really, really, pissy when people demand...
"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
June 10, 2009 at 7:46 am
When you're testing, take a look at the estimated rows for the actual values and the variables. I suspect you'll see substantial differences. For the variables you'll see an average...
"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
June 10, 2009 at 7:44 am
Grant Fritchey (6/10/2009)
Lynn Pettis (6/10/2009)
MarkusB (6/10/2009)
Grant Fritchey (6/10/2009)
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be...
"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
June 10, 2009 at 7:40 am
Lynn Pettis (6/10/2009)
MarkusB (6/10/2009)
Grant Fritchey (6/10/2009)
MarkusB (6/10/2009)
Any psychics around who can help this onehttp://www.sqlservercentral.com/Forums/Topic732091-266-1.aspx
I can't read minds, but I can see the future...
I see... I see... a dba-wanna-be on the...
"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
June 10, 2009 at 7:39 am
Viewing 15 posts - 17,236 through 17,250 (of 22,226 total)