Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,191 through 44,205 (of 59,101 total)

RE: Cursors Be Gone!

Hi Wayne,
I'm not sure what you mean by "how fast you did the coding". Lots of folks posted and I was just one of them... In fact, 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 14, 2009 at 7:24 pm

#977790
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

Wedge78 (4/14/2009)
Hi All
I agree that you can run into problems when using cursors without thought
However I have an instance where I have to gather information from a 3.2 billion row...
--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 14, 2009 at 3:54 pm

#977730
RE: The T-SQL Paradigm

Jim Russell (4/14/2009)
Charles Kincaid (4/13/2009)
Yes, Pete, many cuts. I saw a paper tape reader on a CDC mainframe that had a gear motor an optical sensors.
The optical paper...
--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 14, 2009 at 3:37 pm

#977719
RE: You have 1,000,000 records in your customers table....

Steve Jones - Editor (4/14/2009)
Part of wording the questions is that I have to limit the scope. One way to do that is exaggerate a bit to get you 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)

April 14, 2009 at 10:59 am

#977437
RE: Crosstab type report -- Horizontal Summray

Thank you, Sir. I appreciate the feedback.
Just in case anyone else reads this thread... see what happens when you give us a little data in a readily consumable format?...
--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 14, 2009 at 10:57 am

#977436
RE: Performance issue with tally solution

Phil Factor (4/14/2009)
I ran some tests with my own hot-shot generic split-table-function routine.
Phil, could you post that code here so we have all these fine split functions on one wonderful...
--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 14, 2009 at 8:31 am

#977264
RE: Performance issue with tally solution

David Burrows (4/14/2009)
looks like I'm gonna have to learn C#.
Watch out that your halo does not slip too far Jeff 😉
Heh... Not to worry. I'll wear the tin...
--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 14, 2009 at 8:27 am

#977258
RE: Are the posted questions getting worse?

Lynn Pettis (4/13/2009)
I made a slight change to the data loaded. I kept the data the same in both tables this time and here are the statistics io 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 14, 2009 at 8:19 am

#977250
RE: Manners

Lynn Pettis (4/13/2009)
In my blog, th flip side, I mention that the post should be concise yet detaled. Sort of an oxymoron, but it works.. The code should be...
--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 13, 2009 at 9:31 pm

#977014
RE: Performance issue with tally solution

Bruce W Cassidy (4/13/2009)
Jeff Moden (4/13/2009)
Thanks, Bruce... and sorry I took it the wrong way.
[font="Verdana"]No problem.
I think it's yet another example of using the right tool for the job. ...
--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 13, 2009 at 8:59 pm

#977010
RE: Are the posted questions getting worse?

Ok... I give up... the Tally table part of the code took 22 seconds to do the split. I stopped the function table split after 8 minutes.
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 13, 2009 at 8:08 pm

#977003
RE: Are the posted questions getting worse?

Lynn Pettis (4/13/2009)
I think I found the reason why. If you check the code, the definition field is nvarchar(max). I made some changes to the code, and 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)

April 13, 2009 at 7:29 pm

#976997
RE: Performance issue with tally solution

Bruce W Cassidy (4/13/2009)
Jeff Moden (4/13/2009)
Heh... and the stone throwing from the band wagon begins. 😉 Don't forget, I was the one that first said that Flo's beat 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 13, 2009 at 7:05 pm

#976995
RE: Performance issue with tally solution

Bruce W Cassidy (4/13/2009)
P.S. Phil Factor's blog post makes interesting reading, particularly for this little gem:
Jeff Moden
P.S. Heh... Always say "Never" to a RBAR While loop... 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)

April 13, 2009 at 6:29 pm

#976987
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Paul White (4/13/2009)
Jeff Moden (4/12/2009)
Oh, and have you enabled CLR yet and learnt C#? :laugh:
Heh... no, not yet, Paul.
--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 13, 2009 at 6:17 pm

#976982

Viewing 15 posts - 44,191 through 44,205 (of 59,101 total)