Jeff Moden

Forum Replies Created

Viewing 15 posts - 38,281 through 38,295 (of 59,072 total)

RE: Microsoft Humor

Jeff Moden (5/10/2010)
BWAA-HAA!!! They must be preping us for the next release. 😛
Heh... our system DBA went to the R2 release presentation here in Detroit. He said 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)

May 19, 2010 at 4:30 pm

#1169800
RE: Are the posted questions getting worse?

Steve Jones - Editor (5/18/2010)
No, but Sybase uses T-SQL, so there will be some familiarity with the language and syntax. Thats' about it.
And... IIRC, both are based on the Rushmore...
--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)

May 19, 2010 at 4:20 pm

#1169798
RE: Updating 20M rows takes 5 hours

Stefan_G (5/19/2010)
Dont worry about the clustered index. It should not be disabled.
Just a thought... I haven't looked all through this thread for column names and the like but if 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)

May 19, 2010 at 8:36 am

#1169472
RE: How to Convert Rows into Columns?

Sahasam,
Thanks for the feedback. Before you get rid of the functions, there's a learning opportunity to be had. Create a couple hundred thousand rows and test it against...
--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)

May 19, 2010 at 8:23 am

#1169461
RE: Remove Pattern in sql query

Heh... thanks niteshrajgopal...
It might be more appropriate to say that I know "other people's stuff". I didn't invent any of these methods... I just get lucky putting them together....
--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)

May 19, 2010 at 8:16 am

#1169451
RE: Comparing two rows in one table for changes in column

Oooooohhh.... I think I get it now. Remember when I said we need to define what a change in frequency is? We still need to do that (at...
--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)

May 19, 2010 at 8:06 am

#1169441
RE: Comparing two rows in one table for changes in column

Dobermann (5/18/2010)
Hi Jeff,
Well, this one is closer, but sorry to say still not 100% correct.
When I ran this:
SELECT K9ID, MedID, Dose, Frequency
FROM #RX
ORDER BY K9ID, MedID, RxStartDate
against #RX,...
--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)

May 19, 2010 at 7:49 am

#1169429
RE: Calculating Median and Percentiles

That's a pretty interesting way to calculate "Median". Haven't tried it but it looks fast. I know a different way that we can test together tommorow night. ...
--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)

May 19, 2010 at 1:00 am

#1169252
RE: SQL to manipulate rows of data

Hmmmm... for some reason, the reply didn't "bump" on "Posts Added Today". I hope the OP got notified.
--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)

May 19, 2010 at 12:46 am

#1169246
RE: Remove Pattern in sql query

ColdCoffee (5/18/2010)
THE MAN of SSC
Heh... thanks for the compliment but there's good people on this forum that can improve on that code. Everytime I get lucky and pull something...
--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)

May 19, 2010 at 12:38 am

#1169244
RE: Remove Pattern in sql query

ColdCoffee (5/18/2010)
Jeff Moden (5/18/2010)
niteshrajgopal (5/18/2010)
Hi again, is there anyway I can add to your reputation or something on this forum:-)
Heh... not to worry. CC is building his reputation where...
--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)

May 19, 2010 at 12:33 am

#1169242
RE: SQL to manipulate rows of data

Heh... ok... time to get down to some T-SQL. 😛
The following code builds some test data. Actually, it builds a lot of data just to be sure we have...
--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)

May 18, 2010 at 11:49 pm

#1169234
RE: Arithmetic overflow : Fit 100 into numeric (15,-2)

Jo Pattyn (5/17/2010)
It was the connection option numeric round_abort (Database Properties > Options > Numeric Round-Abort)
That was the weirdest error I've seen in quite a while... thanks for posting what...
--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)

May 18, 2010 at 9:56 pm

#1169211
RE: How to Convert Rows into Columns?

Heh... no response... guess that fell on deaf ears.
Just in case someone is still listening and for the record, the code that Matt Miller posted will blow the doors off...
--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)

May 18, 2010 at 9:53 pm

#1169209
RE: Remove Pattern in sql query

Sorry for the delay... here's an "Inline Table Valued Function" (iTVF) with a bit of flexibility built in. It's not a panacea but it certainly works for this particular...
--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)

May 18, 2010 at 9:24 pm

#1169202

Viewing 15 posts - 38,281 through 38,295 (of 59,072 total)