Viewing 15 posts - 13,321 through 13,335 (of 22,219 total)
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
It has to do with how the GUI collects data. Here's a good article on 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
February 9, 2011 at 7:26 am
kasaranenikiran-725528 (2/9/2011)
Thnanks for all the Info. I did a reload of the table from other source.Regards
Kay
Excellent. I'm glad you were able to recover it.
If this is 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
February 9, 2011 at 6:52 am
SKYBVI (2/9/2011)
but wat about the backups being done in night...
how to know who,when 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 9, 2011 at 6:48 am
Gianluca Sartori (2/9/2011)
Grant Fritchey (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 6:45 am
I suppose on pretty slow systems or off hours that makes sense to try. But on a reasonably heavily used system... you better be very quick with the keyboard.
"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 6:44 am
Viewing 15 posts - 13,321 through 13,335 (of 22,219 total)