Jeff Moden

Forum Replies Created

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

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

Basically, it's just like what's there already... a bunch of identical tables with different ranges of a column or columns. You create a view using SELECT/UNION just like 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 15, 2008 at 5:42 pm

#872086
RE: A Lack of SQL

{said in the same tone that Homer Simpson says "Doooonuuttts"}
Mmmmmmm.... Pork Chops... 😛
--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 5:38 pm

#872084
RE: A Lack of SQL

Grant Fritchey (9/15/2008)
We have our meeting with the CIO on this topic tomorrow. It's a waste of time though because minds are clearly made up. My goal will be to...
--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:34 am

#871905
RE: Calculating Work Days

That's what I really meant... what were the inputs. Thanks for the 13th/14th of this month. I'll give it a 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)

September 15, 2008 at 10:28 am

#871899
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

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