Viewing 15 posts - 13,321 through 13,335 (of 22,224 total)
I think it's possible that might lead to multiple plans (sort of, actually you're likely to see multiple plans for the different strings, but a single plan for the proc),...
"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 10, 2011 at 6:02 pm
Congrats Brandie. That's really wonderful. Well done.
"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 10, 2011 at 11:23 am
Brandie Tarvin (2/10/2011)
Ninja's_RGR'us (2/10/2011)
kasaranenikiran-725528 (2/10/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
February 10, 2011 at 6:33 am
Ninja's_RGR'us (2/10/2011)
kasaranenikiran-725528 (2/10/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
February 10, 2011 at 5:36 am
As soon as you need to start taking direct control over what is running within Maintenance Plans, you've just out-grown them. This is actually kind of a great moment. Now...
"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 9, 2011 at 5:06 pm
I think your assessment of the issue is accurate. I'm glad things are back on track. I'd suggest you might want to set up some statistics maintenance. The auto update...
"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 9, 2011 at 5:00 pm
m.s.blake (2/9/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
February 9, 2011 at 4:58 pm
Not seeing the code, I'm guessing, but I'll bet one or more of your queries are dynamic using EXEC or sp_executeSQL. That would explain why you have two apparent plans...
"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 9, 2011 at 12:54 pm
I'd favor going for the Developer version over SQL Express. There is just so much you can't do with SQL Express that is a standard part of SQL Server. If...
"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 9, 2011 at 12:52 pm
From what you've supplied, it's hard to be sure where the problem is occurring. You're saying that the query is a loop? That could be the problem right there. 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
February 9, 2011 at 12:33 pm
Jan Van der Eecken (2/9/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
February 9, 2011 at 11:36 am
Steve Jones - SSC Editor (2/9/2011)
BACKUP DATABASE MYDatabase to disk = 'c:\mybackup.bak'
runs to the C: drive on...
"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 9, 2011 at 9:13 am
Brandie Tarvin (2/9/2011)
Ninja's_RGR'us (2/9/2011)
Do you have by any chance a copy of the script you use the create or load the table? ...
"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 9, 2011 at 8:45 am
You can't. Not really. There's just so much that can be done with UDF's, like I said.
"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 9, 2011 at 8:40 am
mohammed moinudheen (2/9/2011)
Thank you Grant for the clarification.Usually, I had not taken backups this way 🙂
Thank you Again.
I agree with you. I don't think it's a good way 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
February 9, 2011 at 8:01 am
Viewing 15 posts - 13,321 through 13,335 (of 22,224 total)