Jeff Moden

Forum Replies Created

Viewing 15 posts - 54,811 through 54,825 (of 59,098 total)

RE: deduping query optimization

Hey there PoleCat... long time no "see"...
Is it the goal of this bit of code to update all but the "first" row for each customer what has been entered within...
--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)

September 29, 2007 at 11:06 pm

#737495
RE: More newbie system table help

Sergiy (9/28/2007)
Un-bloody-believable!
How could possibly a dude having no idea about binary get any job in IT industry???
BWAAAAA-HAAAAAAA-HAAAAAA!!!! Oh, stop it! You're killing me!!! 😀 They don't even...
--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)

September 29, 2007 at 10:22 pm

#737493
RE: Sproc calling Sproc

Transactions??? Why do you need transactions for this??? That's the 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)

September 29, 2007 at 10:03 pm

#737491
RE: can we modify system tables in SQL Server 2000?

A little exuberant on Remi's part... but I absolutely agree with Serqiy and Remi... writing to system tables is a form of "Death by SQL"... you will make a mistake...
--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)

September 29, 2007 at 10:01 pm

#737490
RE: Selecting Preformatted Dates in SQL Server 2000

I got the following from a fellow by the name of "Jeff Smith"... it's pretty much spot on and is a long winded version of what Serqiy posted, which is...
--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)

September 29, 2007 at 9:54 pm

#737488
RE: Sproc Design Question

OMG!!! Table driven code! What a concept 😉
Nice job, Serqiy...
--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)

September 29, 2007 at 9:43 pm

#737486
RE: "primary key" in Table Variable

Paul (5/3/2007)
Forget my original question...
Make believe that this has nothing to do with cursors, stored procs or anything else. I just want to know if anyone has ever seen...
--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)

September 29, 2007 at 9:39 pm

#737479
RE: How to update field in multiple Tables in database

Steve Jones - Editor (9/28/2007)
Ouch!
Noted and added to the list.
Heh... when are they going to get to the list I submitted, Steve?
--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)

September 29, 2007 at 9:31 pm

#737476
RE: About tuning store procedure

Bob Fazio (9/12/2007)
The following does a much better job explaining when/why to use table variables.
Also, be careful not to get into optimization overload. I still suggest that you spend...
--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)

September 29, 2007 at 9:26 pm

#737471
RE: Table Size

Normalize 'til it hurts! It'll save lot's of pain later on... kinda like the pain you're going through right now... 😉
--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)

September 29, 2007 at 9:21 pm

#737467
RE: Is this workable

Ninja's_RGR'us (9/29/2007)
Wow, 52 gig of space!!!! That's a lot of crap to put up with ;).
Ouch! Brain freeze! You just reminded me of a girl I used to...
--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)

September 29, 2007 at 9:16 pm

#737463
RE: Is this workable

GilaMonster (9/29/2007)
MSDB is a perfect example of how not to design a database. Every time I have to get data from that DB I end up tearing more hair out....
--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)

September 29, 2007 at 9:11 pm

#737458
RE: Remove Decimals Without Rounding

Did someone say "loop"??? :blink: On a single row????? :sick:
Using a previous example where 5 decimal places are required to be padded with zeros...
DECLARE @i DECIMAL(10,5)
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)

September 29, 2007 at 9:06 pm

#737456
RE: Update Trigger Updates Correct Record In Another Table

Sorry... temporarily lost my mind... I meant CreatedBy and CreatedOn... not "Modified". 🙂
You think it's better to store all data twice on insert?... Once "normal sized" in the original...
--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)

September 29, 2007 at 8:53 pm

#737452
RE: Limit Resources to UGLY query

Thanks, Bob...
First, updating 500K or even a million rows in a single update probably isn't a problem... 20 million is a problem. If you do some testing, I think...
--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)

September 29, 2007 at 4:20 pm

#737430

Viewing 15 posts - 54,811 through 54,825 (of 59,098 total)