Jeff Moden

Forum Replies Created

Viewing 15 posts - 23,911 through 23,925 (of 59,099 total)

RE: Help need in Avoiding Loop

Gosh. Thanks, Lynn. :blush:
--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)

April 9, 2014 at 10:30 am

#1704600
RE: generate random value before @ in email address

dallas13 (4/9/2014)
Thanks Thats much easier.
The example I created has email addresses length=8 but in reality it may be any length and I wanted to just replace as many...
--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)

April 9, 2014 at 6:56 am

#1704482
RE: Help need in Avoiding Loop

born2achieve (4/9/2014)
Hi Jeff,
I totally agree your logic and will follow that. yes of course, knowledge can only be developed when we try.
you are great mentor. thank you.
Thank for 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)

April 9, 2014 at 6:36 am

#1704475
RE: Team Reputation

Jim P. (4/7/2014)
Jeff Moden (4/7/2014)
I have to disagree a bit with the aspect of not saying anything if someone doesn't meet expectations. There's no doubt that not everyone on...
--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)

April 9, 2014 at 12:57 am

#1704385
RE: Find and Replace Injection String in Server 2005

Heh... I tend to blame both. Cruddy tools being used by people that just don't know. It's a deadly combination.
--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)

April 9, 2014 at 12:45 am

#1704383
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

Ray Herring (4/8/2014)
The direction of the discussion has strayed a little bit from the original topic:-P
The behavior you guys are discussing is not specific to Views. it is general...
--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)

April 8, 2014 at 10:21 pm

#1704361
RE: Stairway to Advanced T-SQL Level 4: Using Views to Simplify Your Query

jay 87680 (4/8/2014)
Actually we went back to the original topic which was my disagreement with the following statement:
"In this case SQL Server will still have to join all the tables...
--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)

April 8, 2014 at 10:13 pm

#1704360
RE: Hierarchies on Steroids #2: A Replacement for Nested Sets Calculations

Thanks for the feedback, Kathy. If you get a chance, stop back and let us know how it worked out. I think originally deciding how to create 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)

April 8, 2014 at 10:11 pm

#1704359
RE: Help need in Avoiding Loop

born2achieve (4/8/2014)
Hi Jeff,
I apologize for extending the thread and your time. I did try to browse through articles before i post in this forum. even i tried some sample...
--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)

April 8, 2014 at 10:04 pm

#1704357
RE: Help need in Avoiding Loop

born2achieve (4/8/2014)
Hi Jeff,
One final question about exception. In my sample logic i am suing try catch to get the exception and transaction to rollback if any exception found. ...
--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)

April 8, 2014 at 5:54 pm

#1704345
RE: Help need in Avoiding Loop

Just a couple of tips here...
First, although it's fast, you made the generation of the test data a wee bit complicated and a bit more difficult to read than it...
--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)

April 8, 2014 at 9:13 am

#1704170
RE: Get list of all workers having same SET of Rates

a.myasnikov (4/8/2014)
Just wondering what the grand-masters will say about a checksum solution?
From what I know about checksums they are pretty reliable way to tell one set from the other... ...
--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)

April 8, 2014 at 7:33 am

#1704131
RE: Is there a way?

I haven't tried it but (no pun intended) check out CHECKSUM_AGG in Books Online. It might be just what the docter ordered.
--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)

April 7, 2014 at 9:54 pm

#1704018
RE: Partition key should be part of Primary key

Fredy James (4/7/2014)
I know this is an old post, but completeness of this thread I would like to add the below comments.
DBA as well as Jeff.Mason was partially correct in...
--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)

April 7, 2014 at 9:39 pm

#1704016
RE: Partition key should be part of Primary key

jeff.mason (10/4/2010)
This is just wrong. I know of no requirement like that. Partitioning has nothing to do with referential integrity and it shouldn't even enter into the discussion.
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)

April 7, 2014 at 9:23 pm

#1704013

Viewing 15 posts - 23,911 through 23,925 (of 59,099 total)