Viewing 15 posts - 16,711 through 16,725 (of 22,229 total)
I would say there's no advantage. The normal backup process is very light-handed. It's transactionally aware, so you get good, clean backups, all without interrupting user access. Why 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
August 19, 2009 at 7:58 am
I'd be willing to do it. I like the general concept of a contract-to-hire position.
"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
August 19, 2009 at 7:52 am
I don't have a clue. It'd be fun to have that problem though.
"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
August 19, 2009 at 7:42 am
In addition to the server side trace, you can also, in real time, query the information about procedures and their behavior from dynamic management views such sys.dm_exec_query_stats.
"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
August 19, 2009 at 6:31 am
I wouldn't say there was a "right" solution to this question, but, I'd lean towards option 2 above, or, possibly, depending on your system, a third option:
Data & Logs 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
August 19, 2009 at 6:27 am
I'm pretty sure cold backup is an older term no longer in use for backups. Our Oracle DBA's were performing these things up until last year (don't ask). In 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
August 19, 2009 at 6:22 am
Use SQL Agent to create a job with a schedule that automatically backs up your databases.
"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
August 19, 2009 at 6:20 am
Is that two drives in addition to the operating system and server files location? If not, I'd put the OS on drive 1 and everything else on drive 2. Obviously...
"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
August 19, 2009 at 5:33 am
There are probably (and we're unlikely to ever know) signal processing databases in the NSA that make WoW, YouTube & Google look like rinky-dink Access db's. Just the indications of...
"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
August 19, 2009 at 5:31 am
RBarryYoung (8/18/2009)
"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
August 18, 2009 at 2:23 pm
Kit G (8/18/2009)
Jeff Moden (8/17/2009)[/b]
I guess that's part of what I mean... why wouldn't you correct the original blog?
I can think of one other reason not to edit the original...
"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
August 18, 2009 at 2:17 pm
While I realize that good carpenters don't blame their tools & all that... but when a carpenter is being told he has to drive nails with a coping saw... can...
"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
August 18, 2009 at 12:15 pm
Jeff Moden (8/17/2009)
Grant Fritchey (8/17/2009)
"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
August 18, 2009 at 12:08 pm
SCOTT!
That's a really hard problem, as I'm sure you're aware. I don't have a good answer. You should start a new thread. You might also consider posting that question 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
August 17, 2009 at 7:59 pm
2005/2008 refers to it as a key lookup, but it's the same thing as a bookmark lookup. You can read about it in the books online. It has to do...
"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
August 17, 2009 at 1:01 pm
Viewing 15 posts - 16,711 through 16,725 (of 22,229 total)