Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,811 through 45,825 (of 59,095 total)

RE: SQL or Oracle

Heh... my first program was using punchcards on Unit Record equipment that was "programmed" by putting banana plug wires into a rather large phenolic board that got insert into 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)

January 17, 2009 at 6:10 pm

#928795
RE: Are the posted questions getting worse?

Sushila's last login and post was on 2008-11-27. Last I heard from her, she was just incredibly busy. I sure do miss her good nature... makes the rest...
--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)

January 17, 2009 at 6:06 pm

#928794
RE: Top N sub query workaround - Does it exist?

krypto69 (1/17/2009)
The method I posted above worked...but gives me fewer records...so I'm stuck..
Heh... we are too... you've not posted the CREATE TABLE statements I asked for and you've not posted...
--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)

January 17, 2009 at 5:55 pm

#928793
RE: Hidden RBAR: Triangular Joins

Jeff Moden (1/17/2009)
TheSQLGuru (1/17/2009)
1) http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx. Don't forget to examine the original post mentioned at the top.
Thanks Kevin, and will do.
Oh... those... I've read those before... and, I don't 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)

January 17, 2009 at 5:50 pm

#928792
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/17/2009)
1) http://sqlblog.com/blogs/hugo_kornelis/archive/2007/11/28/poor-men-see-sharp-ndash-more-cursor-optimization.aspx. Don't forget to examine the original post mentioned at the top.
Thanks Kevin, and will 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)

January 17, 2009 at 4:54 pm

#928788
RE: Hidden RBAR: Triangular Joins

TheSQLGuru (1/17/2009)
2) to Joe: there are several implementations for regex that developers (both XP-based and CLR-based) can download and install from the web that work just fine on 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)

January 17, 2009 at 4:53 pm

#928787
RE: Are the posted questions getting worse?

Matt Miller (1/17/2009)
Say it with me: "ricochet"....:)
Heh... DUDE! Did you just call me a hard head? 😛
Anyone remember the ol' "Ricochet Rabbit" cartoons? Or, how about "Quickdraw McGraw"...
--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)

January 17, 2009 at 4:43 pm

#928786
RE: Are the posted questions getting worse?

RBarryYoung (1/17/2009)
Hey, I just read it. That is a great article!
Awesome... thanks for looking it up, Barry. Her mastery of the written word is just an absolute pleasure...
--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)

January 17, 2009 at 4:39 pm

#928785
RE: Are the posted questions getting worse?

GilaMonster (1/17/2009)
Jeff Moden (1/17/2009)
how can you possibly think he's wrong?
Well, it's not that he's wrong. That's a perfectly correct answer, just to a different question. It's the same...
--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)

January 17, 2009 at 4:17 pm

#928782
RE: Calculate pmt in t-sql (like excel)

Sergiy (1/17/2009)
Jeff Moden (1/17/2009)
If I were doing mortgage calculations, and let's assume that the max limit on the mortgage were, say, ummm... a penny less than a billion dollars... which...
--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)

January 17, 2009 at 4:11 pm

#928781
RE: Select Where_Min()

Chad Crawford (1/16/2009)
Thanks RBarry, Matt, Ramesh and Jeff. This is good stuff, and exactly what I needed.
Chad
Thanks for the feedback, Chad.
--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)

January 17, 2009 at 3:58 pm

#928779
RE: Select Where_Min()

RBarryYoung (1/16/2009)
I did test it Jeff. 🙂
And the execution plans are a reliable indication of what SQL Server is doing with a query as long as you remember 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)

January 17, 2009 at 3:55 pm

#928778
RE: Is there a Bug with the Replace() Function in SQL Server 2005

jim.riedemann (1/16/2009)
The length increase is not coming from REPLACE(), it's coming from the SELECT statement. If you run the following PRINT statement you will see that the output is only...
--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)

January 17, 2009 at 3:33 pm

#928769
RE: Solving the "Running Total" & "Ordinal Rank" Problems in SS 2k/2k5

LeeBear35 (1/16/2009)
As like the solution using the Anchor value, I have not seen that "fix" before. I also wondered if the clustered index was generated with a fillfactor=100 is 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)

January 17, 2009 at 3:28 pm

#928768
RE: SQL or Oracle

gints.plivna (1/17/2009)
Informix is dead, err I mean bought by IBM on 2001 😉
Heh.. a death knell for sure... anyone remember Lotus 123 or Symphony? And, if you actually like...
--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)

January 17, 2009 at 3:20 pm

#928763

Viewing 15 posts - 45,811 through 45,825 (of 59,095 total)