Jeff Moden

Forum Replies Created

Viewing 15 posts - 40,981 through 40,995 (of 59,069 total)

RE: Hugh Performance Gap Between SELECT And INSERT

I agree with Grant... there may be some contention in the form of blocking on the table you're inserting into. There may be a couple of other things 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)

November 25, 2009 at 11:48 am

#1084248
RE: Are the posted questions getting worse?

Grant Fritchey (11/25/2009)
I think this'll do it: http://www.sqlservercentral.com/Forums/Topic823712-357-1.aspx
Yowch! The really bad part is, he speaks with such "self confidence" on the subject that the average Joe-Bag'o-Donuts will actually believe...
--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)

November 25, 2009 at 11:20 am

#1084235
RE: Are the posted questions getting worse?

GSquared (11/25/2009)
10 fingers yields 2 to the tenth power, just counting on your fingers
Heh... wouldn't that be 2¹⁰-1?
--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)

November 25, 2009 at 10:36 am

#1084216
RE: Are the posted questions getting worse?

jcrawf02 (11/25/2009)
Alvin Ramard (11/25/2009)
Roy Ernest (11/25/2009)
I sometimes feel that the thread rules us... We dont rule the thread anymore. It has evolved itself into a controlling being
To the new folks...
--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)

November 25, 2009 at 10:31 am

#1084212
RE: General Question

Bru Medishetty (11/25/2009)
That's a fantastic idea Jeff... update this thread when you have created a new thread.
Like I said... maybe I can get Steve to turn it into a Friday...
--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)

November 25, 2009 at 10:27 am

#1084207
RE: General Question

In fact... I have an even better idea. I'll see if I can get Steve to bring it up on the site as a "Friday Poll". That 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)

November 25, 2009 at 10:18 am

#1084204
RE: General Question

Raghavender (11/24/2009)
🙂
Thanks A Lot,
This topic came accorss to me while I was discussing with my friends, they are working in other technologies, like oracle, mysql etc..
They are able to tell...
--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)

November 25, 2009 at 9:58 am

#1084188
RE: Conditional Set-Based Processing: Moving Towards a Best Practice for ETL

MelS-512196 (11/24/2009)
Disagreements are good -- better ideas happen that way. One thing I think that Jeff should take more seriously, though, is that some projects may have constraints that...
--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)

November 25, 2009 at 9:40 am

#1084174
RE: Update HELP

Thanks, Chad... I appreciate the feedback.
--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)

November 25, 2009 at 8:53 am

#1084116
RE: Are the posted questions getting worse?

Grant Fritchey (11/25/2009)
GilaMonster (11/25/2009)
Ok, I vote this as one of the more ... 'questionable' recommendations I've read here recently.
As your log file is very huge, and it is required 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)

November 25, 2009 at 8:49 am

#1084111
RE: Are the posted questions getting worse?

CirquedeSQLeil (11/25/2009)
Alvin Ramard (11/25/2009)
CirquedeSQLeil (11/25/2009)
Is that a 73-way tie for first place on a daily basis?
I can't say Jason. I only have ten fingers so these bigs numbers can...
--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)

November 25, 2009 at 8:47 am

#1084109
RE: Are the posted questions getting worse?

lnoland (11/24/2009)
[highlight=#1]I don't see a way to delete this so I guess you can just ignore it -- my Newbie stripes are showing here. When I posted this I...
--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)

November 25, 2009 at 8:41 am

#1084104
RE: running total

chandreshgeria (11/24/2009)
appx 50000 rows
Thank you... I'll be back after work tonight.
--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)

November 25, 2009 at 6:28 am

#1083940
RE: running total

Lynn Pettis (11/24/2009)
Jeff,
Wouldn't a million row setup show what you are talking about? Of course, you could make it ten million.
Heh... it absolutely would... but he's using MSDE 2000...
--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)

November 25, 2009 at 6:27 am

#1083939
RE: Update HELP

Steve Jones - Editor (11/24/2009)
Jeff,
Nice post, and a great way to handle the phone numbers. I wasn't aware of NPA/NXX, and that's good to know.
I would agree with you that...
--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)

November 24, 2009 at 9:50 pm

#1083803

Viewing 15 posts - 40,981 through 40,995 (of 59,069 total)