Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,041 through 44,055 (of 59,101 total)

RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Samuel Vella (4/27/2009)
atoth (4/27/2009)
I still find I need Cursors when Sending out batches of Email notifications from the Server.
I would love to replace this with set based handling but 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)

April 27, 2009 at 6:36 am

#984300
RE: Are the posted questions getting worse?

RBarryYoung (4/26/2009)
Not trawling for sympathy on anything folks, just wanted to make sure that you knew what the story was...
Dang, Barry... that's a snootful. Get better soon and don't...
--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)

April 26, 2009 at 11:26 pm

#984179
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Nicely done, Barry... I really like the way the story is unfolding in this series... very easy reading, as well. I absolutely agree that you have real life examples...
--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)

April 26, 2009 at 11:11 pm

#984177
RE: Performance issue with tally solution

Wow... Just looked back at some of the graphs.... I've gotta find out which While Loop and Tally table methods Phil used to come up with his graphs because...
--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)

April 26, 2009 at 11:50 am

#984114
RE: Performance issue with tally solution

Florian Reischl (4/25/2009)
@jeff
Sorry, your posted test environment is really good but I need something more flexible and a possibility to run different tests at once.
Heh... no need to apologize, Flo......
--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)

April 25, 2009 at 11:55 am

#983998
RE: Performance issue with tally solution

Paul White (4/25/2009)
The point I was making was that the UNION ALL method and it's derivatives split one row and then copy the results for all subsequent rows. 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)

April 25, 2009 at 11:29 am

#983994
RE: Which country is best for Outsourcing?

Heh... enough about outsourcing. I don't care what country anyone is from, here's to all the good people that "try" and do what's right every bloody day... and damn...
--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)

April 25, 2009 at 11:03 am

#983988
RE: Which country is best for Outsourcing?

umar iqbal (4/23/2009)
and I proud to be an american
where atleast i feel i am free
Gosh, Umar, I wish some of the folks born here felt the same way. ...
--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)

April 25, 2009 at 10:54 am

#983984
RE: Performance issue with tally solution

Paul White (4/25/2009)
One last thing. Using SELECT INTO to create the result table is a bit unfair on any method (e.g. a stored procedure) which cannot be used that...
--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)

April 25, 2009 at 10:31 am

#983978
RE: Performance issue with tally solution

Paul White (4/25/2009)
Hey Flo!
These new tally solutions are only fast if all the rows in dbo.JBMTest are identical.
That's exactly what my testing was showing me. Randomness of position 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)

April 25, 2009 at 10:28 am

#983977
RE: Performance issue with tally solution

Florian Reischl (4/25/2009)
The Article
Sorry that the article is still pending, but it is quiet hard to write an article since all test results still changing... I didn't forget, I just...
--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)

April 25, 2009 at 9:21 am

#983969
RE: Performance issue with tally solution

Florian Reischl (4/25/2009)
@bob-2, Jeff and the rest of the tally masters
This becomes a bit esoteric but as Bob said "if one tally is fast, two are faster"... If my UNION...
--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)

April 25, 2009 at 9:17 am

#983968
RE: Performance issue with tally solution

Derek Dongray (4/24/2009)
Bob Hovious (4/23/2009)
With respect to testing, and I apologize for not having done more, it seems there are at least three or four variables about the test data...
--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)

April 25, 2009 at 9:12 am

#983966
RE: Perform math on string

WayneS (4/24/2009)
GSquared (4/24/2009)
Before you start stuffing the string, make sure that times before 10 AM are stored with leading zeroes. If not, you might have a problem when 9:00...
--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)

April 25, 2009 at 9:08 am

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

Jack Corbett (4/24/2009)
Jeff,
If you send me the test code I can run it in 2008. I have it on my laptop.
Very cool, Mr. Corbett. I'll take you...
--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)

April 24, 2009 at 5:15 pm

#983873

Viewing 15 posts - 44,041 through 44,055 (of 59,101 total)