Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,301 through 39,315 (of 59,098 total)

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
RE: Calculating total working hours exclude launch, smoking...and etc times

Dehqon D. (3/15/2010)
For me SQL is in learning process, hope can get knowledge soon and help to people like you 🙂
P.S: Reposting 3rd time, after waiting after half hour
Ummm... 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 8:10 pm

#1134946
RE: Splitting A String

Paul White (3/16/2010)
The tally-table method ... {snip} ... is far, far, superior.
Almost as good a a CLR string splitting function in fact.
Heh... keepsake that is right thar...
--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 7:13 pm

#1134943
RE: Computed Column Help Please

GSquared (3/16/2010)
Why the complexity?
The SessionID is used to group 2 to 30 people who attended the same meeting e.g The attendee will have a ServiceID(PK), Date, Time, Meeting Room, Speaker,...
--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 7:07 pm

#1134942
RE: Computed Column Help Please

GSquared (3/16/2010)
Jeff, it's c. 60M rows per month, because of the prefix. That's probably enough for most business purposes (unless you're Amazon, Google, et al).
Heh... Yep. I forgot...
--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 7:00 pm

#1134941

Viewing 15 posts - 39,301 through 39,315 (of 59,098 total)