Viewing 15 posts - 18,271 through 18,285 (of 22,219 total)
Bob Hovious (2/20/2009)
I'll drag in another alternate universe and say deploy the thopters to fetch him back before he is devoured by the shai-hulud.
Huh, really? I would have thought that...
"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
February 20, 2009 at 9:34 am
I'm with Bruce. We drop & recreate the indexes when there are massive inserts every night. It usually speeds up the process and you don't get fragmentation.
"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
February 20, 2009 at 8:22 am
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...
"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
February 20, 2009 at 7:42 am
Bob Hovious (2/20/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
February 20, 2009 at 7:40 am
Jeff Moden (2/20/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
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.
"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
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,...
"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
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...
"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
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...
"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
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...
"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
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...
"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
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...
"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
February 20, 2009 at 5:41 am
Bob Hovious (2/19/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
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...
"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
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...
"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
February 19, 2009 at 1:22 pm
Viewing 15 posts - 18,271 through 18,285 (of 22,219 total)