Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,816 through 43,830 (of 59,097 total)

RE: Matrix multiplication without cursors?

In fact... here's a couple of other views concerning world wide browser usage...
http://www.thecounter.com/stats/2009/March/browser.php
http://www.upsdell.com/BrowserNews/stat.htm
http://en.wikipedia.org/wiki/Usage_share_of_web_browsers#Present_to_1999
--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 10, 2009 at 7:48 pm

#991876
RE: Performance issue with tally solution

Phil Factor (5/10/2009)
Jeff Moden
Any word on this, Phil? Copying code from the code windows makes some really ugly stuff with extra line breaks, no indentation, and all those nasty things...
--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 10, 2009 at 7:20 pm

#991874
RE: Matrix multiplication without cursors?

Heh... "Must look eye". That's just for the people that hit the W3Schools website... not what the rest of the world is
doing. Even W3Schools acknowledges that when they included...
--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 10, 2009 at 7:01 pm

#991872
RE: Performance issue with tally solution

UMG Developer (5/10/2009)
I've never heard the phrase to "pork chop" someone what does it mean?
There's a pretty long story behind it, but it basically means taking the person responsible for...
--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 10, 2009 at 6:49 pm

#991871
RE: Performance issue with tally solution

Florian Reischl (5/10/2009)
Hi Jeff
I saw your question and you are correct. If the data are imported by a file this would be the best approach.
But I already started with my...
--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 10, 2009 at 6:35 pm

#991868
RE: Are the posted questions getting worse?

Jeff Moden (5/10/2009)
RBarryYoung (5/10/2009)
Not as I recall. My recollection is that we came up with an alternate way to do it.
Other than using Maxdop, I don't remember coming up...
--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 10, 2009 at 5:20 pm

#991861
RE: Are the posted questions getting worse?

RBarryYoung (5/10/2009)
Not as I recall. My recollection is that we came up with an alternate way to do it.
Other than using Maxdop, I don't remember coming up with an...
--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 10, 2009 at 4:13 pm

#991849
RE: Performance issue with tally solution

I was kind of hoping the data was being imported from a file and that each comment, despite the number of whole and partial lines it may occupy, would 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 10, 2009 at 4:06 pm

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

Very cool. Thanks for the feedback, Manie.
--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 10, 2009 at 3:31 pm

#991840
RE: Performance issue with tally solution

UMG Developer (5/10/2009)
Jeff Moden (5/10/2009)
I'm confused... why would you put over 4 million comments together only to break them apart again?
Because in the source data an individual line may 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)

May 10, 2009 at 3:29 pm

#991839
RE: Matrix multiplication without cursors?

Heh... There're a lot of folks that really only have one option for a browser. And, as far as I know, there are still more people in the world...
--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 10, 2009 at 3:04 pm

#991836
RE: Performance issue with tally solution

I'm confused... why would you put over 4 million comments together only to break them apart again?
--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 10, 2009 at 2:51 pm

#991831
RE: Are the posted questions getting worse?

RBarryYoung (5/10/2009)
Jeff Moden (5/10/2009)
GilaMonster (5/10/2009)
Itzik Ben-Gan mentioned it during his precon at PASS last year. He also mentioned that the other T-SQL trick often used (select @var = @var +col...
--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 10, 2009 at 2:43 pm

#991829
RE: Are the posted questions getting worse?

GilaMonster (5/10/2009)
Itzik Ben-Gan mentioned it during his precon at PASS last year. He also mentioned that the other T-SQL trick often used (select @var = @var +col from tbl) was...
--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 10, 2009 at 10:04 am

#991790
RE: Are the posted questions getting worse?

I don't get it... maybe it was a service pack or something, but even Paul N's odd code produces the correct ordered MAV in 2k5. What the heck are...
--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 10, 2009 at 9:32 am

#991789

Viewing 15 posts - 43,816 through 43,830 (of 59,097 total)