Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,756 through 43,770 (of 59,101 total)

RE: Sum previus rows

Ramesh (5/16/2009)
Yet another running total problem, follow this link that explains the 3 methods on how to calculate running totals.
For advanced method (i.e. Special Update method), see this article[/url] by...
--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 16, 2009 at 9:58 pm

#995934
RE: Eliminating Cursors

Heh... with what Sergiy said in mind... I've always been distraught over the idea of restarting serialization every year and the whole idea of using a sequence table to begin...
--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 16, 2009 at 9:22 pm

#995933
RE: Are the posted questions getting worse?

Lynn Pettis (5/16/2009)
O Please great and wise gurus, for what reasons may SQL Server not allow me to create a nonclustered index?
Heh... don'cha just love homework, test, or interview questions?
--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 16, 2009 at 9:10 pm

#995932
RE: T-SQL

raj_143bhoomika (5/16/2009)
hi , i just need what may be the reasons . If we might across a condition
When creating a non clustered index on a column...
--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 16, 2009 at 9:00 pm

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

Heh... actually, now that I lookback at it, part of the problem was, indeed, an ORDER BY. It was actually a combination of both that killed our TempDB. ...
--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 16, 2009 at 5:18 pm

#995918
RE: Eliminating Cursors

Since the sproc that updates the sequence table is so very important to eliminating the cursors in other procs, the fact that it has to be super fast, and 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 9:41 pm

#995807
RE: Eliminating Cursors

Nah... "my mistrake"... it's ok.
--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:45 pm

#995801
RE: Eliminating Cursors

Jeff Moden (5/15/2009)
Actually, I found a bug in spDBSys_GetTableRowKey_sproc... it will never produce an id of 000001...
In fact, it never produces a new id of other than 000000 even though...
--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:54 pm

#995795
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

Viewing 15 posts - 43,756 through 43,770 (of 59,101 total)