Viewing 15 posts - 6,796 through 6,810 (of 22,226 total)
Any chance your query is using NO_LOCK?
That can absolutely lead to missing 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
February 5, 2015 at 4:35 am
Yeah, someone has 'sa' privileges.
You might also look at the system_health extended event session. It captures some modifications along these lines (but not all).
"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
February 5, 2015 at 4:34 am
I'm with Gail. It's very likely that your process is working, but capture the deadlock graphs from production just to be sure that you're dealing with the same objects. Then...
"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
February 5, 2015 at 4:32 am
ChrisM@Work (2/5/2015)
Grant Fritchey (2/4/2015)
SQLRNNR (2/4/2015)
Grant Fritchey (2/4/2015)
Sioban Krzywicki (2/4/2015)
Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot put, discus,...
"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
February 5, 2015 at 4:06 am
patrickmcginnis59 10839 (2/4/2015)
dwain.c (2/4/2015)
patrickmcginnis59 10839 (2/4/2015)
dwain.c (2/4/2015)
SQL Query invoked by Crystal Reports v9.2 Performance Issue
I'm a great believer in...
"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
February 5, 2015 at 3:52 am
SQL_Surfer (2/4/2015)
Actually, finally came up. But i see only one plan in the cache. Should I be seeing two for parameter sniffing?
No, not for a bad parameter sniffing problem.
"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
February 5, 2015 at 3:51 am
SQL_Surfer (2/4/2015)
As soon as I take the recompile option out, web hangs...Process goes to runnable step and never finishes for me to get to the execution plan.
Get the estimated plan....
"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
February 5, 2015 at 3:50 am
Excellent. Make sure to look at the execution plans to see how the queries resolve based on the new design. Thanks for the follow-up post.
"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
February 5, 2015 at 3:47 am
New Born DBA (2/4/2015)
ScottPletcher (2/4/2015)
"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
February 5, 2015 at 3:45 am
In that case, it's referencing the object, not the call, so the text is showing the object definition.
"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
February 5, 2015 at 3:38 am
Thanks for reporting back what worked. That's really good to know and useful for people who find the question and answers when searching.
"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
February 4, 2015 at 12:53 pm
Brandie Tarvin (2/4/2015)
Ed Wagner (2/4/2015)
Brandie Tarvin (2/4/2015)
"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
February 4, 2015 at 12:13 pm
SQLRNNR (2/4/2015)
Grant Fritchey (2/4/2015)
Sioban Krzywicki (2/4/2015)
Some of it is probably the sport you're focusing on. Two of the sports were football and field events (shot put, discus, javelin). It was...
"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
February 4, 2015 at 12:12 pm
New Born DBA (2/4/2015)
Lowell (2/4/2015)
"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
February 4, 2015 at 10:58 am
SQL_Surfer (2/4/2015)
Or in other words, how do I get the ANSI connection settings from the web app?
Oh, that's easy. Look at the first operator from the execution plan. It's stored...
"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
February 4, 2015 at 10:43 am
Viewing 15 posts - 6,796 through 6,810 (of 22,226 total)