Jeff Moden

Forum Replies Created

Viewing 15 posts - 37,816 through 37,830 (of 59,098 total)

RE: Left Outer Join replace *=

Steve Jones - Editor (7/2/2010)
How's this:
select
Fname
, LName
, Mname
from Employee e
LEFT OUTER JOIN Timekeep t
ON e.employee.id =...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 11:43 am

#1188556
RE: change DateFirst within a funciton

She Through Whom All Data Flows (11/2/2009)
Ok, I'll attempt to explain why. My function fnMfgMonth calculates the "manufacturing month" for a given date. "Manufacturing month" is determined by the week...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 11:31 am

#1188553
RE: Should DBAs Be the Protectors of Data?

I agree with your mentor. So far as I'm concerned, a DBA's only job is to protect the data. Anything and everything else a DBA does is in...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 11:22 am

#1188545
RE: What columns are eligible to be in non clustered index

You can create more than 200 NC indexes on any table if you don't mind duplicates on small tables like this one. With a 5 column table, though, I...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 11:19 am

#1188543
RE: Are the posted questions getting worse?

Jack Corbett (7/3/2010)
Cool! They must be in the developer track because I didn't see them in the DBA track. I'm sure one of them will be selected. ...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 11:06 am

#1188540
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

jyurich (7/3/2010)
I am usually a fan of your posts. However, these articles left a lot to be desired. The examples provided are trivial at best (please do take this the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 10:39 am

#1188533
RE: Error! Msg 103, Level 15, State 4, Line 1

You bet. Thanks for the feedback, Ami.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 10:22 am

#1188532
RE: Are We Not Testing Enough?

Grant Fritchey (7/2/2010)
michael.wiles (7/2/2010)
Grant Fritchey,
You alluded to the fact that you look at work history with applicable knowledge in order to give someone a position. How does someone usually...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 10:11 am

#1188529
RE: Are the posted questions getting worse?

Grant Fritchey (7/2/2010)
Jeff Moden (7/2/2010)
Hey Grant! What day is your local Pass meeting on in July? I'm going to be in lil' Rhody from the 11th to the...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 9:37 am

#1188526
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/2/2010)
I agree with you Jeff. We could only pick from what was submitted, but some of the feedback that I've given is that we ought to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 9:32 am

#1188525
RE: Are the posted questions getting worse?

Jack Corbett (7/2/2010)
Sounds like you need to go on the road. Also submit to the Summit. There is a development track, I didn't get to see any abstracts...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 3, 2010 at 9:30 am

#1188524
RE: Are the posted questions getting worse?

Hey Grant! What day is your local Pass meeting on in July? I'm going to be in lil' Rhody from the 11th to the 17th and I'd love...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 2, 2010 at 3:30 pm

#1188445
RE: Are the posted questions getting worse?

Here's a real life example of what I'm talking about. I gave a 2 hour session at my local Pass chapter. The first hour was an intro to...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 2, 2010 at 3:28 pm

#1188444
RE: Are the posted questions getting worse?

Steve Jones - Editor (7/2/2010)
Part of a problem I see with the whole process is that there aren't good guidelines. No criteria that describe how we pick things.
We did get...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 2, 2010 at 3:23 pm

#1188441
RE: Creating Clustered index on a large table

TheSQLGuru (7/2/2010)
Once again we are moving into the world where a professional would be worth his/her weight in gold - or at least silver (metals are SOOOO inflated in price...
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

July 2, 2010 at 3:16 pm

#1188438

Viewing 15 posts - 37,816 through 37,830 (of 59,098 total)