Viewing 15 posts - 13,336 through 13,350 (of 22,227 total)
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
Kwisatz78 (2/9/2011)
Ok great thanks Grant I will check it out - btw I read your book on Execution Plans very informative 🙂
Thank you! It's good to know it's been helpful.
"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:43 am
It really depends on the business. There are places where nosql is going to, rightly, kick out OLTP systems. There are places where nosql does not belong. Just as 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
February 9, 2011 at 6:37 am
You're unlikely to get someone to do your work for you for free. Instead, you shoul focus your efforts on the things that people have already suggested. Learn about entity...
"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:25 am
I'm fairly certain this was added to the deprecation list in 2005. That means that the very next release of SQL Server will remove it (assuming 2005, 2008, 2008 R2...
"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:19 am
Nope.
It's gone.
You really should reexamine your backup strategies. Once every four months, even in a development environment, is way too long. If it's a production environment, it means that the...
"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:12 am
How are you monitoring the process? If you use sys.dm_exec_requests you can see what the process is waiting on (as well as if other processes are waiting on it). 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 6:05 am
mohammed moinudheen (2/9/2011)
First let the backup command run to take the backup on server location
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:00 am
Viewing 15 posts - 13,336 through 13,350 (of 22,227 total)