Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,931 through 45,945 (of 59,095 total)

RE: Are the posted questions getting worse?

Michael Earl (1/15/2009)
After extensive testing, Aqua Net hair spray ended up being better than any other propellant we could find.
Any build up on the walls over time?
--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)

January 15, 2009 at 6:02 am

#927206
RE: Are the posted questions getting worse?

Chris Morris (1/15/2009)
Top work! What do you use as propellant? Don't tell me...when you're not clearing tables you collect the stuff 😛
Ronson Lighter fluid... it's "ashless".
--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)

January 15, 2009 at 6:00 am

#927203
RE: Are the posted questions getting worse?

RBarryYoung (1/14/2009)
Don't bother, Jeff. I found a photo of you with the Recoiless Pork Chop Launcher from your old delivery job:
Heh... man, you don't know how close that 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)

January 14, 2009 at 11:11 pm

#927078
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Lynn Pettis (1/14/2009)
Different subject, have you had a chance to test my code yourself? After my last test, I feel much better.
No... and today pretty much stunk for doing...
--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)

January 14, 2009 at 10:23 pm

#927066
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Heh... beat you to it. See you tomorrow night.
--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)

January 14, 2009 at 10:18 pm

#927065
RE: Are the posted questions getting worse?

LOL!!! Now, that just figures... :hehe:
--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)

January 14, 2009 at 10:12 pm

#927062
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Heh... it actually doesn't really matter at all... here's why...
SELECT TOP 1000
REPLACE(REPLICATE('=',t.N)+'9','9','88') AS R,
...
--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)

January 14, 2009 at 10:08 pm

#927061
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Test it... you'll find out differently... no warning.
Same holds true for the following...
SELECT REPLACE(REPLICATE('=',7999)+'9','9','88')
Truncation with no warning.
So, there is truncation with no warning for both. To me, 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)

January 14, 2009 at 9:53 pm

#927057
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Sorry... getting a bit tired and, like you said, shouldn't have posted "the short answer". 😀
What happens with the following in SQL Server 2000? 2005?
SELECT STUFF(REPLICATE('=',8000),1,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)

January 14, 2009 at 9:35 pm

#927052
RE: Are the posted questions getting worse?

Greg Edwards (1/14/2009)
I'm thinking Gail is going who needs a 44 Magnum, when you have H&H's around.
Maybe you better think about upgrading Jeff. I'd hate for you to bring a...
--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)

January 14, 2009 at 9:22 pm

#927051
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Heh... I've already seen all of those logical discussions above. Although very well founded, I still just happen to disagree with them.
--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)

January 14, 2009 at 9:06 pm

#927048
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Heh... that's what's cool about discussions on forums... I get to disagree and not hurt anyone's feelings. 😛
Personally, I'd prefer to see the function be a little smarter and, yeah,...
--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)

January 14, 2009 at 8:37 pm

#927042
RE: Common Mistakes in T-SQL

I see that mistake alot, as well... especially by Oracle programmers because you can't write an Oracle trigger using what looks like set based code. You write the trigger...
--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)

January 14, 2009 at 8:33 pm

#927040
RE: How to loop through different tables to modify a single field?

Thanks for the feedback Felix. What did you end up doing?
--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)

January 14, 2009 at 8:01 pm

#927038
RE: Where 1 = 1

John Dempsey (1/14/2009)
I'm with you Jeff. I always use BEGIN TRANSACTION when performing a manual delete. I also use it when I am doing an update also, of...
--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)

January 14, 2009 at 7:58 pm

#927036

Viewing 15 posts - 45,931 through 45,945 (of 59,095 total)