Viewing 15 posts - 8,056 through 8,070 (of 22,219 total)
Security is just the start. I'd suggest modifying the cost threshold for parallelism. I'm just learning about modifying the system_health extended events session to only write to file and not...
"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 4, 2014 at 8:13 am
Steve Jones - SSC Editor (5/30/2014)
Everyone enjoy summer. Last chance to ping me for things before I'm gone for 6 weeks.7 hours and counting....
Enjoy it. See you when you get...
"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
May 30, 2014 at 10:14 am
I've checked in with the powers that be. I suspect pretty strongly that you're misinterpreting that statement, but someone should get back on this, soon I hope.
"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
May 30, 2014 at 3:15 am
Since you have more than one date value, that's returning multiple rows in a place that can only have one. Instead of using MAX date, use TOP 1 with an...
"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
May 30, 2014 at 3:11 am
You need to do two things. Look into all the common code smells of T-SQL, like this:
Isnull(functionalunit, '') <> ''
That's a function on a column which will lead 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
May 30, 2014 at 1:35 am
Age has nothing to do with it. It's down to knowledge and experience. Unfortunately, that's usually accumulated with age. So, it's not that you're too young, it's that you may...
"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
May 30, 2014 at 1:32 am
Unless you're pushing the outer bounds of what large hardware is capable of, the days of easy rejection of virtualization are over. In fact, I'd say, in most cases, virtualization...
"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
May 30, 2014 at 1:26 am
I have not heard about anyone having issues, nor have I. As with Gail though, CTPs are installed on VMs (or, better still, spun up in Azure).
"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
May 30, 2014 at 1:23 am
ramana3327 (5/27/2014)
So we don't need to consider about the user seeks here. Ok. Thank you.
But the indexes you showed were not identical. And, if they're not identical and both...
"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
May 27, 2014 at 9:42 pm
ramana3327 (5/27/2014)
"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
May 27, 2014 at 9:40 pm
I'm just lulling you into a false sense of security.
"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
May 27, 2014 at 9:36 pm
To query the plans in cache you need to use the dynamic management views. Something along these lines could work:
SELECT deqs.execution_count,
deqs.total_elapsed_time,
...
"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
May 26, 2014 at 11:04 pm
According to what you're showing, both indexes have been used. One has been used in seeks and one has been used in scans. Don't worry about updates. Any update 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
May 26, 2014 at 10:05 pm
Have you looked at the execution plans to determine how the optimizer is resolving the existing queries. As Gail said, APPLY doesn't seem like the right tool here.
"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
May 26, 2014 at 1:48 am
Instead of a restart have you tried dropping the procedure plan from the cache to see if it's just a case of bad parameter sniffing? In a development server 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
May 26, 2014 at 1:46 am
Viewing 15 posts - 8,056 through 8,070 (of 22,219 total)