Jeff Moden

Forum Replies Created

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

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
RE: Just Walk Away - Blacklisting - and Twits without Twitter

I knew it would stumble on VARCHAR(MAX)... I just didn't realize how bad. However, on the thread that Flo has been orchestrating, he sent me a PM 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 20, 2009 at 8:54 pm

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

Manie Verster (4/18/2009)
Hi Jeff, you know sometimes you just amaze me! I love your article (got to it a bit late) but I just have one problem. I have not...
--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 8:37 pm

#981160
RE: Which country is best for Outsourcing?

Bob Hovious (4/20/2009)
Can I declare my independence and be a country?
Thought you already had your own "state". 😛
--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 7:54 pm

#981152
RE: Performance issue with tally solution

I'd still like to see what the inputs and outputs of the binary to hex problem look like just to play...
--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:22 am

#980906

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