Jeff Moden

Forum Replies Created

Viewing 15 posts - 24,451 through 24,465 (of 59,102 total)

RE: Sending a Variable Number of Elements in a Parameter

Phil Factor (2/6/2014)
Alex,
I've gone back to have a closer look at the article. It could be that I've misunderstood something, but I really think the first example could be improved....
--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)

February 6, 2014 at 8:10 pm

#1686884
RE: Sending a Variable Number of Elements in a Parameter

Alex Grinberg-230981 (2/6/2014)
I have tested CLR to split a delimited string, much slower and take bigger resources. This why I did include CLR option in my posting.
It would be interesting...
--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)

February 6, 2014 at 7:38 pm

#1686876
RE: Sending a Variable Number of Elements in a Parameter

David McKinney (2/6/2014)
Also, sorry but I find the allusion to plagiarism a little facile. This code is pretty much public domain by now, ...{snip}..., I really don't feel 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)

February 6, 2014 at 6:50 pm

#1686873
RE: Sending a Variable Number of Elements in a Parameter

Qualitas Software (2/6/2014)
Another option or variation on the solutions offered would be to parse the string using CLR ?
We have gone down this route before and, without digging up 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)

February 6, 2014 at 6:37 pm

#1686871
RE: Sending a Variable Number of Elements in a Parameter

Bill Talada (2/6/2014)
Thanks to the article author for braving this group. There is a clique in these forums that just can't seem to let it go when talking 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)

February 6, 2014 at 5:50 pm

#1686866
RE: Sending a Variable Number of Elements in a Parameter

Since my name and my mantra have come up at least once on this thread, I thought I take the time to respond.
Some good folks have stated that they always...
--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)

February 6, 2014 at 5:39 pm

#1686862
RE: How comma separated values are divided into rows?

Scott Coleman (2/6/2014)
Since "I have the input:" doesn't specify where it's coming from, your T-SQL solutions seem to assume that the data is coming from a SQL database. If...
--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)

February 6, 2014 at 4:59 pm

#1686854
RE: Are the posted questions getting worse?

SQLRNNR (2/6/2014)
Sean Lange (2/6/2014)
SQLRNNR (2/6/2014)
Now that an answer or post can be marked as useful and accurate by the OP, I hope that it catches on and people start using...
--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)

February 6, 2014 at 4:24 pm

#1686849
RE: Are the posted questions getting worse?

SQLRNNR (2/5/2014)
Jeff Moden (2/5/2014)
SQLRNNR (2/5/2014)
dwain.c (2/5/2014)
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.
He should come to Michigan. It was snowing to beat the band 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)

February 5, 2014 at 10:44 pm

#1686445
RE: t-sql where statement

I saw that and figured it was just a phat phinger mistake that anyone would be able to fix and so didn't bring it 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)

February 5, 2014 at 10:40 pm

#1686443
RE: t-sql where statement

Heh... Been there and done that. Thanks.
--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)

February 5, 2014 at 10:09 pm

#1686439
RE: Blocked Processes

SQLRNNR (2/5/2014)
ngreene (2/5/2014)
This article may be helpful for your problem.
http://sqlprosperity.com/post/SQL-Server-quasi-real-time-performance-monitoring
It has helped me a lot to identify what processes are causing blocks without having to be on the server querying...
--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)

February 5, 2014 at 10:07 pm

#1686438
RE: t-sql where statement

Keith Tate (2/5/2014)
First please read the article in my signature about posting these types of questions to the forum. After you do that I could make sure that the answer...
--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)

February 5, 2014 at 9:23 pm

#1686431
RE: The Cloud

I wonder when the terms "Internet" and "Cloud" would eventually come to mean the same thing to many people.
You're correct. I fascinated that if I can get to 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)

February 5, 2014 at 9:06 pm

#1686430
RE: Are the posted questions getting worse?

SQLRNNR (2/5/2014)
dwain.c (2/5/2014)
Jeff Moden (2/5/2014)
ChrisM@Work (2/4/2014)
He's calling summer on one sighting of a swallow.
He should come to Michigan. It was snowing to beat the band a couple of days...
--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)

February 5, 2014 at 8:57 pm

#1686429

Viewing 15 posts - 24,451 through 24,465 (of 59,102 total)