Viewing 15 posts - 16,696 through 16,710 (of 22,211 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.
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...
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,...
August 19, 2009 at 6:22 am
Use SQL Agent to create a job with a schedule that automatically backs up your databases.
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...
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...
August 19, 2009 at 5:31 am
RBarryYoung (8/18/2009)
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...
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...
August 18, 2009 at 12:15 pm
Jeff Moden (8/17/2009)
Grant Fritchey (8/17/2009)
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...
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...
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...
August 17, 2009 at 12:42 pm
Jeff Moden (8/17/2009)
GilaMonster (8/17/2009)
Jeff Moden (8/17/2009)
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?
August 17, 2009 at 6:20 am
Viewing 15 posts - 16,696 through 16,710 (of 22,211 total)