Jeff Moden

Forum Replies Created

Viewing 15 posts - 34,021 through 34,035 (of 59,099 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

mishaluba (5/7/2011)
Since this was a pretty long article I had to put it aside and read it over the weekend. Just finished. I have to say this 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)

May 7, 2011 at 2:53 pm

#1321427
RE: need a sp for table update

Arti Dev.06 (5/6/2011)
ohhhh, worked:w00t:...thnx a tonnnn Jack...!!!
i'll b back wid new simple question, though tough for me...
Since you're new to SQL, my recommendation is the you look at an online...
--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)

May 7, 2011 at 1:41 pm

#1321422
RE: Are the posted questions getting worse?

GilaMonster (5/7/2011)
Jeff Moden (5/7/2011)
GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
You can only say that once. I don't know if you had anything to do with it but...
--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)

May 7, 2011 at 1:11 pm

#1321421
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

WayneS (5/7/2011)
Jeff Moden (5/7/2011)
Does anyone else have any other suggestions for a speed enhancement before I do that?
:ermm: Have you tested Peso's/Peter's code that he sent you yet? His code...
--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)

May 7, 2011 at 1:07 pm

#1321420
RE: EAV's and NVP's are bad. So... What do YOU use as an alternative?

SQLRNNR (5/3/2011)
Until recently I was biased against them having had extremely bad experiences with them. I have seen an implementation where it seems to work rather well. Thus,...
--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)

May 7, 2011 at 12:12 pm

#1321406
RE: EAV's and NVP's are bad. So... What do YOU use as an alternative?

GSquared (5/3/2011)
I've used them. Those and XML columns both work for "user-defined data structures". Which one I use depends on degree of flexibility needed and how it's going...
--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)

May 7, 2011 at 12:06 pm

#1321401
RE: EAV's and NVP's are bad. So... What do YOU use as an alternative?

Ross McMicken (5/3/2011)
I've seen them used very successfully in applications where the end users have choices on configuration.
...
I've used EAV tables to store configuration data in cases where it made...
--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)

May 7, 2011 at 12:02 pm

#1321400
RE: EAV's and NVP's are bad. So... What do YOU use as an alternative?

Thanks for the replies and my apologies... I lost track of this thread for a while because of all the activity on an article discussion.
--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)

May 7, 2011 at 11:58 am

#1321399
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

At this point, I thought Shannon didn't really want to strip characters... only find those "cells" that had unwanted characters. At the very least, LIKE NOT would likely make...
--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)

May 7, 2011 at 11:53 am

#1321398
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Craig Farrell (5/7/2011)
Jeff Moden (5/6/2011)
Shoot, I may even find a reason to use SSIS, SSAS, or SSRS someday in the future. 🙂
I take it me beating you with them until...
--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)

May 7, 2011 at 11:49 am

#1321396
RE: Are the posted questions getting worse?

Gianluca Sartori (5/6/2011)
Jeff's latest article is great, and the discussion rocks.
If you haven't checked it yet, go and have a look!
I love this community.
I'm absolutely tickled with the way 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)

May 7, 2011 at 11:45 am

#1321395
RE: Are the posted questions getting worse?

GilaMonster (5/6/2011)
Off to SQLSaturday, the first one in Africa
You can only say that once. I don't know if you had anything to do with it but congratulations either way....
--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)

May 7, 2011 at 11:43 am

#1321394
RE: Are the posted questions getting worse?

Brandie Tarvin (5/6/2011)
Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.
Editor's Note:
...
--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)

May 7, 2011 at 11:21 am

#1321392
RE: JUST FED UP with SSIS. Simple copy of 800 tables to another database...

bimplebean (5/5/2011)
We realized that all we wanted to do was to move all report-related objects out of the production database so that reporting would survive in the event of an...
--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)

May 7, 2011 at 11:08 am

#1321391
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Craig Farrell (5/5/2011)
Shannon, to confirm, in the end, you wanted something like this:
What I was thinking is that no Tally Table is necessary for this. I believe a LIKE...
--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)

May 7, 2011 at 11:02 am

#1321390

Viewing 15 posts - 34,021 through 34,035 (of 59,099 total)