Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,726 through 43,740 (of 59,063 total)

RE: Eliminating Cursors

Actually, I found a bug in spDBSys_GetTableRowKey_sproc... it will never produce an id of 000001...
--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 15, 2009 at 7:50 pm

#995793
RE: Eliminating Cursors

praveenvelumula (5/15/2009)
Thanks for advice .. Jeff ,
I will work on it .. I think i can do ....if not ...can i get back to you again ..........
Praveen
Absolutely....
--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 15, 2009 at 7:34 pm

#995792
RE: Eliminating Cursors

RBarryYoung (5/15/2009)
Jeff Moden (5/15/2009)
Praveen,
What version of SQL Server are you using? 2k, 2k5, 2k8?
Oops! I forgot to ask. Dang, I would have fallen hard on that one!
Heh... "Must...
--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 15, 2009 at 7:22 pm

#995789
RE: Eliminating Cursors

praveenvelumula (5/15/2009)
Hi Jeff Moden
allowed to change spDBSys_GetTableRowKey_sproc ... not many dependencies ...
Praveen
Perfect. I didn't mean to post just a quote and we can't delete posts anymore. SO,...
--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 15, 2009 at 7:19 pm

#995787
RE: Eliminating Cursors

praveenvelumula (5/15/2009)
I din't mean you to rewrite the store proceudre ... Just i need advice ..
to replace the Cursor ...........which i need to implement for better performance
i need...
--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 15, 2009 at 6:59 pm

#995784
RE: Eliminating Cursors

Sorry, Praveen... I have another question....
Are you allowed to change spDBSys_GetTableRowKey_sproc so long as it doesn't break any code?
--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 15, 2009 at 6:38 pm

#995779
RE: Eliminating Cursors

praveenvelumula (5/15/2009)
Microsoft SQL Server 2000 - Enterprise Edition on Windows NT -Service Pack 1
Thanks Praveen.
The code has a sequence table in it instead of using identities... the way...
--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 15, 2009 at 6:25 pm

#995777
RE: Eliminating Cursors

Praveen,
What version of SQL Server are you using? 2k, 2k5, 2k8?
--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 15, 2009 at 4:50 pm

#995755
RE: "tempdb" size -- 550GB!

Robert (5/15/2009)
See if there is any kind of sort in execution plan. Cross join can produce a huge result, but not necessarily anything in tempdb.
If you have an "order...
--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 15, 2009 at 8:17 am

#995370
RE: "tempdb" size -- 550GB!

Attila (5/15/2009)
I'd recommend to run a trace, and look for autogrow events.
Paralelly start a script which runs in every minutes, and writs out the inputbuffer of each spid>49, plus 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)

May 15, 2009 at 8:14 am

#995364
RE: Is a Temporary Table Really Necessary?

alex (5/15/2009)
> I am not fond of cursors and advocate doing anything possible to replace the cursor
What do you gain by handling the looping yourself rather than just using a...
--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 15, 2009 at 8:12 am

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

I found the code I used to gen a Tally table on the fly using what Oracle calls "Subquery Refactoring" which is a fancy name for "CTE". Add a...
--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 14, 2009 at 9:44 pm

#995037
RE: Checksum value for finding changed data advice

Haven't need to try it. I'm pretty fortunate in that most of the data providers I "meat" up with respond pretty well at the mere threat of a malstrome...
--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 14, 2009 at 8:23 pm

#995018
RE: "tempdb" size -- 550GB!

Barkingdog (5/9/2009)
Jeff,
Per the Extimated Execution Plan, TableA (with 60 millon rows) uses about 56% of the query for a table scan! (I will investigate the "predicate" shown in 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)

May 14, 2009 at 8:05 pm

#995012
RE: Checksum value for finding changed data advice

Got it and mostly agree especially since CHECKSUM is not a guarantee that something has changed or 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)

May 14, 2009 at 7:58 pm

#995009

Viewing 15 posts - 43,726 through 43,740 (of 59,063 total)