Viewing 15 posts - 7,396 through 7,410 (of 22,226 total)
Estimated 20, Actual 861K.... Uhm, I'm thinking a seek is absolutely a bad thing for this query to be running. Are we looking at a bad parameter sniffing? Really bad...
"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
October 10, 2014 at 4:14 pm
You might want to look into external management of this type of long running distributed transaction. The BizTalk server[/url] is build around managing this sort of thing..
"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
October 10, 2014 at 4:09 pm
Sure thing. I've got a video up here of deadlock information in SQL Monitor.
"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
October 10, 2014 at 4:06 pm
Thanks for walking through that. I kept meaning to get to it, but didn't have the 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
October 10, 2014 at 3:50 pm
You might try SQL Search from Red Gate[/url].
And before anyone freaks, it's completely free.
"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
October 10, 2014 at 10:22 am
RUN AS is a secondary set of permissions you'd need as well. Security is fun.
"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
October 10, 2014 at 7:52 am
With the huge variety of things going on within SQL Server, I've no doubt there are places or instances where you'll see faster performance. But they're going to be 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
October 10, 2014 at 6:25 am
You're not simply nesting the functions, you're self-referencing. That's very different, and, as you're seeing in the error message, not allowed.
"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
October 10, 2014 at 6:22 am
ERStudio by Embarcadero is one of my favorites.
"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
October 10, 2014 at 6:09 am
No. You can't.
The language for manipulating SQL Server is T-SQL. Not HTML. That stands for Hyper Text Markup Language. Transaction Structured Query Language is for SQL Server. They are 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
October 10, 2014 at 6:09 am
I'd suggest looking at a few more pieces of information. What are your wait statistics like. And, check this article for a few more[/url]. Note, the query that shows 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
October 10, 2014 at 6:07 am
The domain account that Agent is running in will need to have permissions set for it.
"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
October 10, 2014 at 6:02 am
Best suggestion, you take it a step at a time. Be structural in your approach. Understand what's happening and why, then make adjustments to change the behaviors you don't like....
"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
October 10, 2014 at 5:03 am
Totally wild stab in the dark, but what's the fill factor on the index?
"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
October 9, 2014 at 3:46 pm
santoshkal (10/9/2014)
when i run the query it always taking non clustered index scan on execution 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
October 9, 2014 at 8:18 am
Viewing 15 posts - 7,396 through 7,410 (of 22,226 total)