Viewing 15 posts - 13,036 through 13,050 (of 22,227 total)
First thing that jumped out at me: dbo.AncestorsAndDescendantsOfSubAccount(@subacct) Family
Is that a multi-statement user defined function? If so, that's where I'd start. Eliminate that.
Without an execution plan, it's hard to know...
"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
March 15, 2011 at 9:48 am
Sorry, just trying to understand. I saw remote and local and inferred. Remember, I'm not there. I'm just going off what I'm told.
When you say remote, do you mean remote...
"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
March 15, 2011 at 8:37 am
that makes sense. I've heard of getting dupes in identity, but i think it was a one-off bug or something. Certainly nothing standard.
"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
March 15, 2011 at 8:29 am
Sounds like a simple security setting. Go to the SQl Server Configuration Manager and ensure that the SQL Agent service is running with an appropriate login. I'd suggest using 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
March 15, 2011 at 7:18 am
Without going to a third party product, your options are extremely limited to already having configured the system to restore a filegroup as outlined above, or doing a full restore...
"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
March 15, 2011 at 7:16 am
Are you doing anything at all to the identity column as part of your insert processes? I only ask because, while I've seen issues around identity, not generating a unique...
"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
March 15, 2011 at 7:10 am
Yeah, I agree. Start at the exec plans and see if there are differences there. But, the biggest difference to me is that one database is local and the other...
"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
March 15, 2011 at 7:08 am
Kit G (3/15/2011)
Grant Fritchey (3/15/2011)
Jeff Moden (3/14/2011)
"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
March 15, 2011 at 6:43 am
You're confusing two sets of functionality. The variables in Visual Studio are just part of the build and deployment, not a part of coding. All they really are is SQLCMD...
"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
March 15, 2011 at 6:37 am
EasyBoy (3/14/2011)
Grant Fritchey (3/14/2011)
"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
March 15, 2011 at 5:38 am
Jeff Moden (3/14/2011)
"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
March 15, 2011 at 5:36 am
I tried to open those files, but couldn't get either to open.
It sounds like, based on the description, parameter sniffing. For identical parameters values, are the plans different? I...
"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
March 14, 2011 at 3:21 pm
You don't have to drop the database. You just have to move the files and overwrite the existing database.
But I am confused by your initial question. You said that 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
March 14, 2011 at 11:39 am
Lowell (3/14/2011)
"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
March 14, 2011 at 11:34 am
Have you checked out this book on PBM?
"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
March 14, 2011 at 9:45 am
Viewing 15 posts - 13,036 through 13,050 (of 22,227 total)