Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,936 through 43,950 (of 59,063 total)

RE: Performance issue with tally solution

I'll take a look, Paul. Thanks.
--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 1, 2009 at 11:07 am

#987440
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

JohnG (5/1/2009)
If you do create a TALLY table, for whatever purpose, in Oracle my recommendations are:
1. Create it as an Indexed Organized Table (IOT) using the ORGANIZATION INDEX clause. ...
--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 1, 2009 at 10:53 am

#987436
RE: Performance issue with tally solution

Almost forgot... the reason why I don't use the code windows anymore is because, although they may work fine with FireFox, they suck when using IE7. The remove blank...
--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 1, 2009 at 6:31 am

#987235
RE: Performance issue with tally solution

Florian Reischl (4/30/2009)
We had a performance issue in conjunction with STUFF? Maybe, I'm just gone blank... :doze:
Maybe it's just me and I'm thinking of the wrong person. It 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 1, 2009 at 6:27 am

#987231
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

JohnG (4/30/2009)
Actually not. Don't worry about large IN lists in Oracle. I've had subqueries returning thousands - 10s of thousands of rows fed into an IN list. ...
--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 30, 2009 at 5:05 pm

#987086
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

That would be the ANSI standard for UPDATE... subqueries for each field(s) being updated. If you do such a thing in SQL Server, the duration of the update increases...
--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 30, 2009 at 2:59 pm

#986988
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Heh... I wonder if the ANSI committee like pork chops. 😉
--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 30, 2009 at 1:20 pm

#986890
RE: Are the posted questions getting worse?

RBarryYoung (4/30/2009)
Chris Morris (4/30/2009)
@Barry - get well soon mate, that sounds like some horrible stuff you're dealing with. You will be hugely missed while you're away for the op.
Thanks, Chris....
--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 30, 2009 at 10:44 am

#986778
RE: How to split one mdf file into two

DKG (4/30/2009)
Of couse this is not a good practive to take backup on DVDs
I'd say the jury is still out on that one for smaller systems. With compression, 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 30, 2009 at 10:29 am

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

Well stated... but doesn't that show that embracing OOP took even longer for most folks? 😉 I believe that was the real point trying to be made. :hehe:
--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 30, 2009 at 10:26 am

#986760
RE: Performance issue with tally solution

Florian Reischl (4/30/2009)
Jeff Moden (4/29/2009)
http://www.sqlservercentral.com/articles/T-SQL/63003/
Thanks Jeff!
Great article! Am I allowed to refer to?
Greets
Flo
Absolutely.
I also have some code for you on cleaning a string. I've repaired the performance problem...
--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 30, 2009 at 10:22 am

#986757
RE: UPDATE column with auto number depending on field value ?!

DECLARE @counter int
SET @counter = 0
UPDATE custom.table1
SET @counter = table1.number = @counter+1
Also, since you got that to execute previously, you may have to add an "anchor" column and it should...
--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 30, 2009 at 10:18 am

#986754
RE: UPDATE column with auto number depending on field value ?!

m.berggren (4/30/2009)
Hi, i tried this one but i got some syntax errors again. It´s complaining about the "=" in row 4. Maybe beacuse this is written in Sybase (interactive sql)...
--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 30, 2009 at 10:16 am

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

greatheep (4/29/2009)
Unfortunately, it doesn't work out that way - we tried a single set based approach originally, and we almost always had the whole thing roll back due to concurrency...
--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 29, 2009 at 11:59 pm

#986446
RE: Problem: Equal Checksums for different values

The problem is that CheckSum_Agg just does a simple XOR. You can cheat... it's no guarantee, but it's more likely to find something different...
DECLARE @CS1 bigint
SET @CS1 =...
--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 29, 2009 at 11:41 pm

#986436

Viewing 15 posts - 43,936 through 43,950 (of 59,063 total)