Viewing 15 posts - 6,796 through 6,810 (of 22,219 total)
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
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 less than twice...
"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:41 am
Without more evidence, I don't know.
It could just be bad parameter sniffing. It could be something else. Gather to data to be sure.
"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:37 am
It's also possible that you're seeing differences in the plan because of ANSI connection settings being different between SSMS and the web app. Because, assuming you ran the query with...
"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:18 am
This usually has one of two causes. The first, and the easiest, is that your statistics need to get rebuilt. They'll be rebuilt automatically as you use them, but they'll...
"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:16 am
Eirikur Eiriksson (2/4/2015)
Sioban Krzywicki (2/4/2015)
Grant Fritchey (2/4/2015)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what he's talking about?
Nah, I hear he's a giant bag 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
February 4, 2015 at 8:45 am
shew (2/4/2015)
Grant Fritchey (2/4/2015)
My book has been updated very extensively for SQL Server 2014.
I ran across a copy of your "SQL Server 2012 Query Performance Tuning" book this morning. This...
"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 8:42 am
Brandie Tarvin (2/4/2015)
Grant Fritchey (2/4/2015)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what he's talking about?
Nah, I hear he's a giant bag of wind 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
February 4, 2015 at 8:21 am
Viewing 15 posts - 6,796 through 6,810 (of 22,219 total)