Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,026 through 41,040 (of 59,069 total)

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

Before I get started... the article is well written, clear, and easy to understand... I just disagree with the premise of having to resort to any form of RBAR for...
--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 23, 2009 at 7:24 pm

#1083226
RE: Optimizing Cursor Performance

I agree with that whole heartedly, DC. I've found that a well written cursor will frequently beat a home grown While Loop just as you said. I'll also...
--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 23, 2009 at 5:41 pm

#1083214
RE: Are the posted questions getting worse?

Bob Hovious 24601 (11/23/2009)
The article is intended to help novices "get" the fact that there aren't hard and fast answers to some questions.
Heh... a little play on words... to Novices,...
--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 23, 2009 at 5:26 pm

#1083213
RE: running total

chandreshgeria (11/22/2009)
Sir ,
I have not seen any sake in performance of executing query , can you help it out where I doing Wrong
...
--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 23, 2009 at 5:16 pm

#1083212
RE: Convert searched String to number

andy.woodward (11/23/2009)
That makes a lot of sense Jeff thankyou.
The database holds thousands and thousands of records so I will definately benefit from the speed aspect.
Just one question.
you have set 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 23, 2009 at 4:02 pm

#1083199
RE: How using SQL to generate random string?

I'm actually a bit surprised at the high numbers of rejects... seems like for a base 36 set of 6 characters, there should only have been a "chance" of about...
--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 23, 2009 at 3:44 pm

#1083194
RE: Rounding - Is there a better way

Heh... no problem... I just like to know what drives such requirements. Thanks for 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 23, 2009 at 7:57 am

#1082941
RE: need sample resume for MS SQL DBA

sanketahir1985 (11/20/2009)
Hiii All
I need sample resume for SQL DBA,
can any body guide me, [font="Arial Black"]where will i find the sample resumes[/font].
sanketahir1985 (11/23/2009)
hey i know that how to search on google...
--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 23, 2009 at 6:21 am

#1082905
RE: REPLACE Multiple Spaces with One

Understood but thanks for the reminder...
The real problem is that this type of thing should never happen... it's simple and easy to prevent. Data providers that cough up...
--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 23, 2009 at 6:09 am

#1082900
RE: How using SQL to generate random string?

Dave Ballantyne (11/23/2009)
Hee Hee, No worries Jeff, constructive criticism always welcome 😛
Heh... you're taking it well. Thanks. Just curious... does that mean you're going to change...
--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 23, 2009 at 5:59 am

#1082895
RE: How using SQL to generate random string?

Heh... crap... I didn't realize that it was Dave's article. Didn't mean to blast one of our own but I guess everyone know's I'm serious about it now.
Sorry Dave...
--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 22, 2009 at 7:52 pm

#1082790
RE: How using SQL to generate random string?

No problem with what you posted... I understood what you were doing, Ron and I appreciate it because you're exactly right... folks need to get away from thinking "loops". ...
--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 22, 2009 at 7:43 pm

#1082788
RE: REPLACE Multiple Spaces with One

Paul White (11/22/2009)
(which I still admire BTW)
Heh... The odd thing is, I don't deserve that... like I said in the article, it's an old method and I didn't come up...
--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 22, 2009 at 6:57 pm

#1082783
RE: REPLACE Multiple Spaces with One

Paul White (11/22/2009)
Jeff Moden (11/22/2009)
Paul White (11/22/2009)
5. Actually, don't do data access at all in functions!! Unless you really really really know what you are doing, and 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)

November 22, 2009 at 6:51 pm

#1082782
RE: REPLACE Multiple Spaces with One

C# Screw (11/22/2009)
Of course I agree with your comments - just trying to find a neat solution to handle clean up of all sorts of junk.
Heh... I'm sure that what...
--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 22, 2009 at 6:48 pm

#1082781

Viewing 15 posts - 41,026 through 41,040 (of 59,069 total)