Viewing 15 posts - 18,256 through 18,270 (of 22,202 total)
Nothing. Sleeping & dormant processes are ones that are still working. The real thing to look for is blocked or blocking processes. If none of those, then you need to...
February 20, 2009 at 7:42 am
Bob Hovious (2/20/2009)
February 20, 2009 at 7:40 am
Jeff Moden (2/20/2009)
February 20, 2009 at 7:37 am
I'm pretty sure they'd be absolutely identical, but run them with profiler or look at the STATISTICS IO output to verify.
February 20, 2009 at 7:12 am
I haven't run into it either. Have you run the Upgrade Advisor? There are things that you must change prior to upgrading the database. If you haven't run the Advisor,...
February 20, 2009 at 7:10 am
You can only update one table at a time, yes, but you can wrap all the updates within a transaction. That will make them all "occur" at the same time.
Probably...
February 20, 2009 at 6:21 am
I do feel for you. I've been there. Trying to convince a programmer who knows everything there is to know that, maybe, just maybe, he's not quite up to snuff...
February 20, 2009 at 5:56 am
I'm a little surprised at the "it's not DBA specific" statements. For those who don't know, yes, this site is focused on SQL Server, but it's not a DBA specific...
February 20, 2009 at 5:51 am
Steve Jones - Editor (2/19/2009)
That's great. 😀Fortunately I've worked at and been in a reactor so I'm not more nervous than I would otherwise be.
Having done several valve alignments after...
February 20, 2009 at 5:43 am
Lynn Pettis (2/19/2009)
What, not like he's asking how to write a database to support a nuclear reactor system.
You don't know that, and that's what scares me. I mean think about...
February 20, 2009 at 5:41 am
Bob Hovious (2/19/2009)
February 20, 2009 at 5:39 am
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
Lynn Pettis (2/19/2009)
Put down the keyboard and back away slowly and noone will get hurt...How do you think this OP would do in our mock interview?
I'm going...
February 19, 2009 at 1:24 pm
josephptran2002 (2/19/2009)
Hi Thereyou are right, my mistake
But After I fix the DDS of one table then it says "Invalid Object Name 'dbo.BOCLEARED' "
DO YOU KNOW WHY
Usually that means that...
February 19, 2009 at 1:22 pm
GilaMonster (2/19/2009)
Grant Fritchey (2/19/2009)
Lynn Pettis (2/19/2009)
Put down the keyboard and back away slowly and noone will get hurt...How do you think this OP would do in our mock interview?
I'm going...
February 19, 2009 at 1:18 pm
josephptran2002 (2/19/2009)
Hi there,How can I copy the script of my CREATE TABLE?
THank you
P.S: I'm new to SQL, sorry I try to learn as fast as I can
Right click the table...
February 19, 2009 at 1:17 pm
Viewing 15 posts - 18,256 through 18,270 (of 22,202 total)