Viewing 15 posts - 16,711 through 16,725 (of 22,226 total)
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
At my current company we've tried one offshore outsourcing of a single development project because it would "save money" not to mention deliver the project faster, and it would work...
"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 12:42 pm
Jeff Moden (8/17/2009)
GilaMonster (8/17/2009)
Jeff Moden (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 17, 2009 at 12:19 pm
jp (8/17/2009)
I dont agree with most of the points listed here.. :w00t:
Which, the original 20 or the comments that followed?
"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 6:20 am
Viewing 15 posts - 16,711 through 16,725 (of 22,226 total)