Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,271 through 39,285 (of 59,072 total)

RE: Calculating total working hours exclude launch, smoking...and etc times

Dehqon D. (3/16/2010)
Hi Forum,
I'm so sorry that I posted the same massage again and again. I'm totally new, and I didn't realize that my posts are getting 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)

March 16, 2010 at 10:22 pm

#1134979
RE: Are the posted questions getting worse?

29 is also my record for the number of pork chops I've had in the air at the same time. I was pretty ticked that day... 😛
--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)

March 16, 2010 at 10:04 pm

#1134976
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
GilaMonster (3/16/2010)
137 - The inverse of the 'fine structure constant'.
...and the 33^rd prime number. Retaining the theme of a, you should probably also use 29 (the 10^th...
--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)

March 16, 2010 at 10:03 pm

#1134975
RE: T-SQL: Why “It Depends”

ith the last couple of posts in mind, I hope everyone realizes that the big brother to "It Depends" is "Test it!". 😉
--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)

March 16, 2010 at 10:00 pm

#1134972
RE: GROUP BY in SSIS SQL Query for 35+ million rows

In my eyes, 20GB for such a database is probably ok but a bit large. My suggestion would be to reexamine the underlying methods and, as already suggested, maybe...
--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)

March 16, 2010 at 9:36 pm

#1134966
RE: Are the posted questions getting worse?

Roy Ernest (3/16/2010)
137 consistency errors...
Isnt that the number of parameters for DBCC TIMEWARP ?:-D
... and the number on my old beer mug. :hehe:
--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)

March 16, 2010 at 9:17 pm

#1134961
RE: Are the posted questions getting worse?

Roy Ernest (3/16/2010)
I got 3 rounds of back side kicking ... 🙂
Heh... rookies all... pork chops are the only way to go. 😛
--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)

March 16, 2010 at 9:14 pm

#1134960
RE: Are the posted questions getting worse?

Roy Ernest (3/16/2010)
CirquedeSQLeil (3/16/2010)
Roy Ernest (3/16/2010)
I got my $500 yesterday. If I can write an article there, anyone here can write it for sure. 🙂
You wrote an article for 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)

March 16, 2010 at 9:13 pm

#1134959
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
GSquared (3/16/2010)
Good point. I've used that one. Easy enough to put an explicit date in there. Same way I do when I need to do...
--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)

March 16, 2010 at 9:12 pm

#1134958
RE: Are the posted questions getting worse?

GSquared (3/16/2010)
Paul White (3/16/2010)
jcrawf02 (3/16/2010)
Paul White (3/15/2010)
In fact it is as bad as DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP), 0).
All right Paul, edumacate me. Why is this bad?
Zero is not a date...
--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)

March 16, 2010 at 9:10 pm

#1134957
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
jcrawf02 (3/16/2010)
Paul White (3/15/2010)
In fact it is as bad as DATEADD(DAY, DATEDIFF(DAY, 0, CURRENT_TIMESTAMP), 0).
All right Paul, edumacate me. Why is this bad?
Zero is not a date any...
--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)

March 16, 2010 at 9:07 pm

#1134955
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
Isn't Bob's/Dixie's article an excellent read today?
Shame about some of the layout, but hopefully that will be fixed soon.
Most enjoyable.
It is, indeed!
--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)

March 16, 2010 at 8:58 pm

#1134951
RE: Are the posted questions getting worse?

Lynn Pettis (3/16/2010)
[font="Comic Sans MS"]Party at the Tent in the Desert. The Hippo has been alerted that guests will be arriving.[/font]
This post is number 10,001
Freakin' awesome! #4 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)

March 16, 2010 at 8:56 pm

#1134950
RE: Are the posted questions getting worse?

Paul White (3/16/2010)
GilaMonster (3/16/2010)
I feel another blog rant coming.
See if you can include that http://en.wikipedia.org/wiki/Argument_from_authority link. Very cool.
Other thing that frustrates me, along the same lines, is people insisting...
--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)

March 16, 2010 at 8:53 pm

#1134949
RE: select random records but for each category

mister.magoo (3/16/2010)
I hope you don't take that the wrong way - it was meant to be helpful - albeit in a late night / tired / rubbish way 😀
Heh... we've...
--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)

March 16, 2010 at 8:26 pm

#1134947

Viewing 15 posts - 39,271 through 39,285 (of 59,072 total)