Viewing 15 posts - 13,741 through 13,755 (of 22,224 total)
What's the deal. You guys can't keep your girl friend satisfied? She sent me four messages last night. She's begging for attention. Come on on gentlemen. Do your duty.
"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
December 30, 2010 at 5:35 am
There is no completely reliable method for retrieving this information. Almost any method you use can be spoofed because a given table is only accessed once a month/quarter/year and 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
December 29, 2010 at 1:43 pm
GRANT CREATE TABLE ON SCHEMA::MySchema TO MyUser
You'd need to do that for PROCEDURE, VIEW, etc.
"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
December 29, 2010 at 1:39 pm
Koen (da-zero) (12/29/2010)
Grant Fritchey (12/29/2010)
Yes a full backup every night means that you should be able to recover up to the last full backup. And, yes, you're right, without...
"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
December 29, 2010 at 12:22 pm
ankur_libra (12/29/2010)
Hi Grant,Thanks for the response and Sorry for posting my question here.:crying:
With regards,
Ankur
No big deal. Like I said, for future reference.
It can just lead to confusion when people...
"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
December 29, 2010 at 9:17 am
Jack Corbett (12/29/2010)
Hello My New Friend.
Good Day and How are you today.
Please...
"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
December 29, 2010 at 9:02 am
ankur_libra (12/29/2010)
The similar case is with one of our clients which are using the Symantec Backup Exec 12.5. They have also purchased SQL Agent license from MS. 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
December 29, 2010 at 9:00 am
Since SQL Server is turned off, yes, those backup files are useful. They can be used to reattach a database in the event of a disaster. Now, you won't have...
"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
December 29, 2010 at 8:16 am
check sys.dm_exec_sessions to be sure you're seeing all connections. sys.dm_exec_requests only shows active connections.
"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
December 29, 2010 at 8:14 am
GilaMonster (12/29/2010)
I am really struggling for inspiration for a 24hop abstract. Would a session title 'Bad plan! Sit!' intrigue people, or kill them with laughter?
Ha! You'd get a few, for...
"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
December 29, 2010 at 7:50 am
Brandie Tarvin (12/29/2010)
"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
December 29, 2010 at 7:50 am
Apologies. I think that might have sounded more argumentative than I meant for it to.
I agree. There are a number of ways to skin this particular cat. None of them...
"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
December 29, 2010 at 7:46 am
If it's all for a single application, I'd go with schema's to seperate out storage, access, security. This way you can have referential integrity across the schema's as needed, something...
"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
December 29, 2010 at 7:44 am
For the absolute best PowerShell training, I recommend tracking down Don Jones and seeing when he's offering a class in your area. His training is excellent.
"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
December 29, 2010 at 7:42 am
I'm not sure what the problem might be, but why are you taking a differential backup at one minute intervals, but only backing up the log once an hour. 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
December 29, 2010 at 7:40 am
Viewing 15 posts - 13,741 through 13,755 (of 22,224 total)