Viewing 15 posts - 18,286 through 18,300 (of 22,226 total)
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
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: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...
"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:17 pm
josephptran2002 (2/19/2009)
Select Sum(b.BOCLEARED) AS BOTotal, Sum(c.CTCLEARED) AS CTTotal, Sum(m.MECLEARED) AS METotal, Sum(n.NHCLEARED) AS NHTotal, Sum(r.RICLEARED) AS RITotal, Sum(w.WOCLEARED) AS WOTotal,...
"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:12 pm
Why move all the data to a new table? You can just query the existing tables. I assume the DDS column is some kind of key?
SELECT SUM(b.BOCLEARED) AS BOTotal
,SUM(c.CTCLEARED) AS...
"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 12:30 pm
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 in. This could...
"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 12:26 pm
GilaMonster (2/19/2009)
Edit: Or maybe not. How have I managed to not notice this guy so far?
Alvin Ramard (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 19, 2009 at 12:23 pm
I'm carrying about 15 pounds I don't need (and no, it's not my head. I need it. I need two) and it does slow you down. I used to run...
"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 11:44 am
It's on the standard toolbar by default. Button all the way at the end looks like a chart of the stock market.
"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 11:14 am
Viewing 15 posts - 18,286 through 18,300 (of 22,226 total)