Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,211 through 36,225 (of 59,067 total)

RE: Are the posted questions getting worse?

Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post...
--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)

October 28, 2010 at 12:53 am

#1243360
RE: Are the posted questions getting worse?

Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post it 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)

October 28, 2010 at 12:05 am

#1243348
RE: Are the posted questions getting worse?

Paul White NZ (10/27/2010)
...the author should definitely be shown as Phil McCracken 😎
Now THAT's entertainment! 😀
--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)

October 27, 2010 at 10:17 pm

#1243317
RE: Are the posted questions getting worse?

Here's what I quickly came up with to act as both the introduction to the article and the "teaser" for the news letter for the "Ordering by Months" article...
[font="Arial Black"]SQL...
--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)

October 27, 2010 at 10:11 pm

#1243316
RE: Are the posted questions getting worse?

Craig Farrell (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
pin a post in that forum? Or others? Don't want to pin in every forum.
Shame you can't have those two links just be...
--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)

October 27, 2010 at 9:51 pm

#1243305
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
Jeff Moden (10/27/2010)
I'll be happy to do the "Ordering months by number" thing. Like Lynn says, though, it would really be helpful if we...
--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)

October 27, 2010 at 9:50 pm

#1243304
RE: Ordering by month, show name

I'll take this one on.
--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)

October 27, 2010 at 9:35 pm

#1243298
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
OK, sign up for articles. Please just pick one, then another when you finish.
If you have ideas, feel free to post them, but try 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)

October 27, 2010 at 9:34 pm

#1243297
RE: In Line Subquery versus Join query

am-244616 (10/27/2010)
Guys,
I am trying to figure out the advantages and disadvantages in terms of performance for in line sub query versus join based query.
In the below query the EMPLOYEE_TYP and...
--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)

October 27, 2010 at 8:51 pm

#1243285
RE: Get the Current Date

CELKO (10/27/2010)
[In ANSI the syntax would be more natural since it uses plus and minus and the ability to use year-month-day and hour-minute-second intervals.
.
.
.)
Likewise, a mixed interval
...
--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)

October 27, 2010 at 8:41 pm

#1243281
RE: Hidden or Unknown Job Perks

I have to say that the perks I enjoy are a whole lot less obvious. I'm really starting to dislike working for "publically owned" companies because of all 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)

October 27, 2010 at 8:19 pm

#1243275
RE: BCP in

jez.lisle (10/27/2010)
Nope... I mean you can if you want but BULK INSERT may be a better option. It's very similar to BCP except that it doesn't require the use of...
--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)

October 27, 2010 at 8:15 pm

#1243274
RE: Is this "global recession" over?

tosscrosby (10/25/2010)
10.1 percent in the US, not seasonally adjusted....Like that'll make a huge impact!
And that only includes the people who haven't given up and are still being reported...
--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)

October 27, 2010 at 8:14 pm

#1243272
RE: Are There That Many GUIDs?

Steve Jones - SSC Editor (10/27/2010)
Some of the smaller manufacturers aren't careful. In the 90s we had two separate NICs have duplicate MACs when we bought an off brand.
I know...
--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)

October 27, 2010 at 8:09 pm

#1243269
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
I'll drop some topics out here for you. Here's a couple that I have saved up:
- Finding/changing the default backup location
- scheduling a trace
- duplicating...
--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)

October 27, 2010 at 8:05 pm

#1243268

Viewing 15 posts - 36,211 through 36,225 (of 59,067 total)