Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,011 through 41,025 (of 59,102 total)

RE: UPDATE question

PiMané (11/25/2009)
Thanks for the help but the problem with that is if I make
UPDATE table SET col1 = col1, col2 = col2, col3 = 'xxxx' WHERE id = 1
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)

November 25, 2009 at 12:02 pm

#1084259
RE: SELECT and REPLACE query

john scott miller (11/24/2009)
declare @oldip varchar(100)
declare @newip varchar(100)
select distinct oldip
, newIp
, 0 processed
into #ips
from tableName
while exists ( select top 1 * from #ips where processed = 0...
--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:53 am

#1084254
RE: SELECT and REPLACE query

Magy (11/25/2009)
Oh Im sorry, for oldIp I actually meant something like this:
UPDATE myTable
SET linkURL = REPLACE(linkURL, '192.49.42.39', '192.49.21.44')
Actually, you should include the WHERE clause that Nabha used in his nearly...
--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:50 am

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

Viewing 15 posts - 41,011 through 41,025 (of 59,102 total)