Jeff Moden

Forum Replies Created

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

RE: Which country is best for Outsourcing?

I've been very disappointed with every outsourcing venture we've had, so far. Examples include such things as code that has UDF's that call 4 levels of UDF's and 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)

April 22, 2009 at 9:58 am

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

RBarryYoung (4/22/2009)
WayneS: yeah, what Jeff said. Sorry 🙂
Heh... no need to be sorry... it's a very common typing mistake that I occasionally make myself. The names 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)

April 22, 2009 at 9:51 am

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

Try Master.sys.SYScolumns instead... it contains at least 11,000 rows which will produce up to 121 million rows with a single cross-join. And, although it looks fine, double cross joins...
--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 22, 2009 at 12:03 am

#981957
RE: Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Thanks, Manie. I sure do appreciate the feedback.
--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 21, 2009 at 11:57 pm

#981953
RE: Performance issue with tally solution

Bob Hovious (4/21/2009)
Flo and Jeff, I just had to try.
This beast features double-barelled carburetors.... errrr tally tables.... one with two columns, and nested CROSS APPLYs.
Can 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 21, 2009 at 11:16 pm

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

Milovan Banicevic (4/21/2009)
Can I achieve same result WITH NO CURSOR applied???
Absolutely... see the following article (Look for "One final split trick")...
http://www.sqlservercentral.com/articles/TSQL/62867/
... and the following post where many, many different solutions...
--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 21, 2009 at 11:12 pm

#981945
RE: Performance issue with tally solution

Paul White (4/21/2009)
Morning Flo!
On first look, the performance improvement is down to the QO choosing a much more sensible plan when a VARCHAR is used, rather than a MAX datatype....
--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 21, 2009 at 5:10 pm

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

David Burrows (4/21/2009)
Maybe someday, I can teach Jeff something.
Me too, I await that day also :w00t:
Like I've told others, I learn something new from each thread I read. I've...
--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 21, 2009 at 11:20 am

#981649
RE: Are the posted questions getting worse?

Hey, Steve... do they send you any kind of notification if an abstract for PASS has been accepted? And, considering things like agressive spam filters, is there a place...
--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 21, 2009 at 11:14 am

#981644
RE: Performance issue with tally solution

Edward Boyle (4/20/2009)
My strings usually have less that 20 "tokens"
Edward.... first, please understand that I'm absolutely NOT trying to be a wise guy here...
I've found that many folks use 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 21, 2009 at 10:02 am

#981584
RE: Performance issue with tally solution

RBarryYoung (4/21/2009)
Despite the different actual numbers, we usually find that the relative numbers track pretty well across different severs.
However, in my experience there are three factors that are not well...
--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 21, 2009 at 9:52 am

#981572
RE: Performance issue with tally solution

Phil Factor (4/21/2009)
http://www.sqlservercentral.com/Forums/FindPost696606.aspx
Thanks, Phil.
--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 21, 2009 at 9:49 am

#981568
RE: Performance issue with tally solution

Phil Factor (4/21/2009)
For the particular string-splitting function, then the WHILE loop, and the Quirky Update solutions, behave predictably and linearly.
Sorry Phil... Haven't been able to keep up on this thread...
--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 21, 2009 at 5:35 am

#981330
RE: The T-SQL Paradigm

Peter, don't be as bad as the cause. 😉 Lots of us got mad at him for all the name calling. And, the etymology of the word...
--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 20, 2009 at 11:16 pm

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

Matt Whitfield (4/20/2009)
But - I have to say it - I can't think of a way of getting round bruce.t's problem - which I personally found really disappointing!
I may...
--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 20, 2009 at 9:08 pm

#981166

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