Jeff Moden

Forum Replies Created

Viewing 15 posts - 48,316 through 48,330 (of 59,095 total)

RE: A Lack of SQL

I see that some folks think of the CLR vs T-SQL as a turf war. Gosh, I wish people wouldn't think that. I do wish they'd do some...
--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)

September 15, 2008 at 10:21 am

#871892
RE: A Lack of SQL

Grant Fritchey (9/15/2008)
One thing I'm aware of in our organization, and I think it's universal. Object oriented developers loathe TSQL. I've watched blood pressures visibly rise in meetings when 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)

September 15, 2008 at 10:11 am

#871876
RE: Patindex

Carla Wilson (9/15/2008)
Jeff, thanks for that great test script. I like your code for building 1,000,000 row table. I'm saving this code for reference.
Thanks for pointing out how...
--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)

September 15, 2008 at 10:05 am

#871863
RE: "For each table in database......"

Ummmm... wouldn't a nice partitioned view work well here?
--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)

September 15, 2008 at 9:50 am

#871848
RE: Developers' access to dev SQL Server

Depends on what type of DBA you have (see previous post). And, again, it doesn't matter if you limit the people on the Dev box or not if 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)

September 14, 2008 at 10:16 am

#871551
RE: Splitting a String in SQL - Help Please!

Sergiy (9/14/2008)
Single quotes are for test strings.
They are not from file, of course. 🙂
And, I believe, there are 7 columns in both strings.
1st one should be split into:
1Pick-up
2
3
41234
52008-08-24
6 "2008-08-24"
717", unknown...
--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)

September 14, 2008 at 10:04 am

#871550
RE: ANSI PADDING, Trailing Whitespace, and Variable Length Character Colum

Jack Corbett (9/13/2008)
Thanks, Jeff. I actually put a lot more time into the code than the article.
Yeah, I know that it is turned off by default at 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)

September 13, 2008 at 11:53 pm

#871518
RE: Customer Ranking

Heh... yeah, it's an attention getter for sure.
Start by clicking on "Write for us" in the vertical column at the top left of this whole thread. Then, click 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)

September 13, 2008 at 11:48 pm

#871517
RE: I AM HAVING THIS UNIQUE AND STUPID SITUATION IN SSIS FROM MAINFRAME

I think 3 separate directories might be a bit of overkill, but if that works for you, good enough. 🙂
--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)

September 13, 2008 at 11:40 pm

#871516
RE: Splitting a String in SQL - Help Please!

I count 8 columns in the first line and only 7 columns in the second line. Is that correct? And, the single quotes on each end are 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)

September 13, 2008 at 11:28 pm

#871515
RE: I AM HAVING THIS UNIQUE AND STUPID SITUATION IN SSIS FROM MAINFRAME

But, that's the whole problem. Your code is loading the file names of the full files and that's not the right thing to do. Your code should only...
--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)

September 13, 2008 at 9:59 pm

#871510
RE: Patindex

Heh... "Crap happens". 😛
--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)

September 13, 2008 at 9:50 pm

#871509
RE: Developers' access to dev SQL Server

Heh... good analogy... unless you don't realize that you're on the same team.
You guys need to sit down and hammer out your differences, not so that anyone wins but 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)

September 13, 2008 at 9:43 pm

#871507
RE: Splitting a String in SQL - Help Please!

Greig,
When you get a chance... all I need to know is are you splitting a single parameter or do you need to split a whole column of these? 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)

September 13, 2008 at 7:48 pm

#871498
RE: Splitting a String in SQL - Help Please!

Mike DiRenzo (9/13/2008)
Use the Tally table, join to it, then use intrisinc SQL functions because you will have postive indexes to work with. Good luck.
Who's that directed to, Mike?
--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)

September 13, 2008 at 7:45 pm

#871496

Viewing 15 posts - 48,316 through 48,330 (of 59,095 total)