Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,396 through 34,410 (of 59,099 total)

RE: Is any built in function availble in SQL Server 2008 which handle comma seperated values and return as table?

WayneS (4/2/2011)
I wonder how well a CLR function of the .net SPLIT function would perform...?
Oddly enough, I've just (sent an email 15 minutes ago) asked Paul White to 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)

April 2, 2011 at 1:13 pm

#1306788
RE: Convert CSV values in three columns to rows

Just thought I'd do a followup on this. I've managed to fix the problem with the apparent Tally Table slowdown as it approaches 8k. I've got an article...
--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 1, 2011 at 6:30 pm

#1306742
RE: Are the posted questions getting worse?

GilaMonster (4/1/2011)
Roy Ernest (4/1/2011)
Today is a sad day for me personally and to add more pain to it I had a car accident. My body hurts badly. My car 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)

April 1, 2011 at 5:37 pm

#1306734
RE: Are the posted questions getting worse?

Roy Ernest (4/1/2011)
Today is a sad day for me personally and to add more pain to it I had a car accident. My body hurts badly. My car is just...
--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 1, 2011 at 5:25 pm

#1306729
RE: Are the posted questions getting worse?

Trey Staker (4/1/2011)
Congrats Paul!! IMHO he was an MVP way before Microsoft realized it.
I couldn't have said it any better myself. Congratulations Paul!
--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 1, 2011 at 5:22 pm

#1306727
RE: HELP ME !

As a bit of a side bar, notice that the current number of visits to SSC is precisely "1". The OP hasn't even checked to see if any 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)

April 1, 2011 at 5:18 pm

#1306725
RE: HELP ME !

Koen Verbeeck (4/1/2011)
Jeff Moden (3/31/2011)
Raunak Jhawar (3/31/2011)
Moderators,
Please mark this post as a spam and request you to close this thread.
Heh... nah... let it stand to show what we won't help...
--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 1, 2011 at 5:14 pm

#1306723
RE: Trying to check for the existence of a table

Ah... ok. From the code example you gave, I'm not sure if you're trying to drop an actual Temp Table or an expendible table in the current database. ...
--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 1, 2011 at 4:57 pm

#1306720
RE: When to do column only encryption?

I've also seen folks that do it just the opposite. Encrypt the item you're trying to find and look that up in the encrypted column. Makes for 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)

April 1, 2011 at 1:17 pm

#1306664
RE: Trying to check for the existence of a table

Compared to the database you're running this code from, where is the table to be dropped? If it's in another database, then OBJECT_ID isn't going to work as you...
--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 1, 2011 at 1:13 pm

#1306663
RE: Recursive query for a Bill of Materials table

David, you have mail. Please check your "SPAM Locker" as it seems than my ISP has been labeled as a source of SPAM.
--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 1, 2011 at 12:09 pm

#1306642
RE: What columns should be chosen when partitioning a table?

kwoznica (4/1/2011)
Thanks to both of your for the feedback. I'll give that document a read through today. I think I'll be able to use the document no_ column I described....
--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 1, 2011 at 12:04 pm

#1306639
RE: Moving Data... does it really need to be so complicated?

Thanks, folks. I'll go back and look again.
--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 1, 2011 at 7:47 am

#1306482
RE: Recursive query for a Bill of Materials table

david.moule (4/1/2011)
Many thanks for the reply Jeff. I'll work on a test routine as per your first link in your signature block.
With work pressure it could take me 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)

April 1, 2011 at 7:22 am

#1306467
RE: Finding unique values in strings

David Krauus (3/27/2011)
Thanks Jeff, (and others) for taking your time to try to help me.
I am out of town for a few days and wont be able to try...
--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)

March 31, 2011 at 7:42 pm

#1306275

Viewing 15 posts - 34,396 through 34,410 (of 59,099 total)