Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,026 through 44,040 (of 59,097 total)

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

Johan,
Run the first test using the clustered index as it is. Then, drop the clustered index and add a new one based on some other columns. Run your...
--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 7:12 pm

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

Andrew L. Smith (4/27/2009)
Barry:
I agree with this for the most part, but have an exception that I would like to see if you have an answer for. For example, 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:49 pm

#984796
RE: Performance issue with tally solution

Lynn Pettis (4/27/2009)
Flo...
Since there was no production problem I had, after this input I could show my chief some really great new things and it causes that some parts 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 27, 2009 at 6:42 pm

#984794
RE: Performance issue with tally solution

Florian Reischl (4/27/2009)
Hi Adam
The String Enumerator (I just called it "String Enumerator" for better understanding what it does) performs very good! Especially for more rows. I just tried with some...
--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 pm

#984793
RE: Performance issue with tally solution

Adam Machanic (4/27/2009)
Hi all,
I have posted a more scalable SQLCLR string split method here:
http://sqlblog.com/blogs/adam_machanic/archive/2009/04/26/faster-more-scalable-sqlclr-string-splitting.aspx
Thanks to Paul White for pointing me to this thread. Please consider testing all of these...
--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:30 pm

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

And, sorry... I read past it in the previous post. Lynn is correct... you can only execute extended stored procedures in a function. But what good would 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)

April 27, 2009 at 6:07 pm

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

JJ B (4/27/2009)
the vendor has designed their application to force a row-by-row approach because they don't know any better. So as you say, you don't really have a choice other...
--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:02 pm

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

Bruce W Cassidy (4/27/2009)
Look Ma, no cursor! (Yes Jeff, I know it's just as bad as a cursor... it's still row-by-row.)
I find the syntax of cursors annoying and...
--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 5:57 pm

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

Andy DBA (4/27/2009)
Thanks for the post! I bet that blows the function based approach out of the water!
Like anything else, it depends... I've seen it go both ways. ...
--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 10:56 am

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

Samuel Vella (4/27/2009)
Any cursor based operation can be replaced with an external application 😛
Absolutely true. But it's still amazing to me what people actually think they need a cursor...
--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 10:53 am

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

Samuel Vella (4/27/2009)
Jeff Moden (4/27/2009)
Heh... in SQL Server 2005, even that can be done without a cursor. We're just gonna have to wait for it in Barry's series 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 27, 2009 at 10:48 am

#984501
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

Viewing 15 posts - 44,026 through 44,040 (of 59,097 total)