Viewing 15 posts - 12,916 through 12,930 (of 22,227 total)
I'm not sure why someone would say that SCOM is not good for that type of job. In fact SCOM is pretty much designed around specifically that. It would be...
"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 29, 2011 at 7:05 am
If you're looking to do versions of data, you might want to take a look at this article[/url] I wrote for Simple-Talk. Better still, take a look at the comments....
"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 29, 2011 at 6:40 am
The share has to be accessible, but then you just use the UNC path for it:
RESTORE ... FROM DISK = '\\servername\sharename\filename'
Since the filename is likely to be different each 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
March 29, 2011 at 6:36 am
Based on how it works, no, I wouldn't recommend it. If you already have an artificial unique identifier on the table, why do you need a second one? Does 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
March 29, 2011 at 6:22 am
Is there more slack time over weekends or is it the same schedule? You could use that time for doing full backups and then do differentials during the week. 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
March 29, 2011 at 5:57 am
One of the problems with triggers is that they're difficult to control. Based on what you've just outlined, what about having two different processes for updating the data and one...
"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 29, 2011 at 5:51 am
WayneS (3/27/2011)
Grant Fritchey (3/27/2011)
Jeff Moden (3/26/2011)
Koen Verbeeck (3/25/2011)
(but maybe again, someone picks this up not...
"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 27, 2011 at 1:30 pm
Jeff Moden (3/26/2011)
Koen Verbeeck (3/25/2011)
(but maybe again, someone picks this up not realizing it is...
"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 27, 2011 at 12:00 pm
Jeff Moden (3/24/2011)
Grant Fritchey (3/24/2011)
Jeff Moden (3/24/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 25, 2011 at 9:50 am
mtillman-921105 (3/24/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 25, 2011 at 9:18 am
jcrawf02 (3/24/2011)
Stefan Krzywicki (3/24/2011)
Kiara (3/24/2011)
Kit G (3/24/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 24, 2011 at 12:25 pm
Stefan Krzywicki (3/24/2011)
Kiara (3/24/2011)
Kit G (3/24/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 24, 2011 at 11:48 am
Kiara (3/24/2011)
Steve Jones - SSC Editor (3/24/2011)
Brandie Tarvin (3/24/2011)
Kiara (3/24/2011)
The movie named Starship Troopers seems to have only shared its title with the actual book... *sigh*
True (rumored) fact. Starship Troopers...
"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 24, 2011 at 11:06 am
Stefan Krzywicki (3/24/2011)
Grant Fritchey (3/24/2011)
Gianluca Sartori (3/24/2011)
Grant Fritchey (3/24/2011)
Gianluca Sartori (3/24/2011)
Grant Fritchey (3/24/2011)
Roy Ernest (3/24/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 24, 2011 at 11:04 am
mtillman-921105 (3/24/2011)
Grant Fritchey (3/24/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 24, 2011 at 11:02 am
Viewing 15 posts - 12,916 through 12,930 (of 22,227 total)