Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,976 through 48,990 (of 59,093 total)

RE: How to calculate sum of row

Jeffrey Williams (8/3/2008)
I would (personally) forget about any process that updates or tries to maintain this column using a trigger. I would just create it as a computed 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)

August 3, 2008 at 4:34 pm

#852471
RE: How to calculate sum of row

Sorry, was in a hurry. I should have posted them (more than 1) without even being asked.
There are a couple of ways to do it... the method with 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)

August 3, 2008 at 10:23 am

#852443
RE: Parameter as Column Name

koosubscriptions (8/3/2008)
Is there any performance cost compare with if the query already exists?
Thank you.
Probably not... it would probably recompile even if it were hard coded just because of data changes...
--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)

August 3, 2008 at 10:00 am

#852439
RE: How to calculate sum of row

That will work just fine, but only if a single row is inserted at a time. If there's a chance that more than 1 row can be inserted at...
--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)

August 3, 2008 at 9:54 am

#852435
RE: Get rid of cursors

For what? The original code you posted?
If so, why not just insert the header information in a set based manner and then use that information to control another set...
--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)

August 3, 2008 at 9:41 am

#852431
RE: LEFT JOIN vs EXCEPT

Good point, Carl. 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)

August 3, 2008 at 9:28 am

#852430
RE: Cursor vs. Common Table Expression

Barry... you might want to look for the word "Cursor" in the above script... 😀 Heh, late nite posts get me, too! 😉
Other than that, nice conversion! 🙂
--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)

August 3, 2008 at 9:17 am

#852428
RE: Copy comma delimitted text file to a table by ascending order

vkres1 (8/2/2008)
Jeff,
rbarryyoung is telling it is eaier with identity column. Do you know how to figure out with
identity column?looks like clustered index is not guaranteed as you said. any idea
Thx
rbarryyoung...
--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)

August 3, 2008 at 9:12 am

#852427
RE: Beat this - comic relief for the day

rbarryyoung (8/2/2008)
Jeff Moden (8/2/2008)
The DBA was nothing but a BSOFH.;)
Uuuhh, ... "Big Stupid Old Fart-Head"?
Heh... Ummm... no... what's your user name again? 😉
http://members.iinet.net.au/~bofh/bofh/bofh2.html
http://members.iinet.net.au/~bofh/
The "SO" stands for "SysOP"... you can figure...
--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)

August 2, 2008 at 11:05 pm

#852396
RE: Copy comma delimitted text file to a table by ascending order

vkres1,
Forget about the identity column... if you want to store the data in the correct physical order, then put a clustered index on the column(s) that you want the data...
--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)

August 2, 2008 at 10:46 pm

#852394
RE: Copy comma delimitted text file to a table by ascending order

rbarryyoung (8/2/2008)
Of course, the order problem can be easily remedied if you just add an Identity column. 🙂
I don't think it will, especially if parallelism kicks in. If...
--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)

August 2, 2008 at 10:31 pm

#852393
RE: comparing 2 consecutive rows in SQL

Try your code, Barry. 🙂
--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)

August 2, 2008 at 7:56 pm

#852382
RE: Copy comma delimitted text file to a table by ascending order

Ummm... you're missing the point a bit. The order in which something is inserted doesn't really matter in an RDBMS. Why do you think you need a "natural...
--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)

August 2, 2008 at 2:54 pm

#852365
RE: Oracle books for Sql server DBA

That's why I put "new" in parentheses... haven't need MERGE in SQL Server 😉
--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)

August 2, 2008 at 2:47 pm

#852364
RE: Deleting 400K rows

The loop idea isn't actually a bad one (I refer to it as a "DELETE CRAWLER"), but deletes, by themselves, run pretty quickly depending on the criteria. I'd limit...
--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)

August 2, 2008 at 11:26 am

#852342

Viewing 15 posts - 48,976 through 48,990 (of 59,093 total)