Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,831 through 43,845 (of 59,063 total)

RE: Problem segregating third occurence from a column

Gianluca Sartori (5/7/2009)
... ooops!
I vote for Lynn's solution! There's also an interesting thread on this topic
http://www.sqlservercentral.com/Forums/Topic695508-338-1.aspx
Uh huh... just be careful with what you see in some of the posts...
--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, 2009 at 11:05 am

#990533
RE: Newbie Question about replying to a post

jamiejulius (5/7/2009)
Is there any difference between using the "Reply+" button next to a specific post and the "Add Reply" button at the bottom? Conceptually, I assume that the former would...
--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, 2009 at 11:00 am

#990527
RE: How to split one field into many

GSquared (5/7/2009)
If you have a Numbers/Tally table, this will do that kind of thing:
select substring(@String + ',', Number, charindex(',', @String + ',', Number) - Number)
from dbo.Numbers
where Number <=...
--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, 2009 at 10:58 am

#990525
RE: SET vs SELECT

JohnG (5/7/2009)
Jeffrey Williams (5/7/2009)
Not worried about whether or not I do it right (or you do it right), more concerned about the person who comes behind and does not realize...
--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, 2009 at 10:41 am

#990506
RE: Improving data import performance - More RAM ?

Jeff Moden (5/6/2009)
ifila (5/6/2009)
I still get nulls in the Account Table 🙁
Thanks
Are all of the files you're trying to import in the exact same format and field order?
I can 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)

May 7, 2009 at 10:34 am

#990501
RE: Enhancing the readability of your code: Table aliasing in sql

tlehner (5/7/2009)
Steve Jones - Editor (5/7/2009)
For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:
However, I...
--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, 2009 at 10:16 am

#990483
RE: Enhancing the readability of your code: Table aliasing in sql

Steve Jones - Editor (5/7/2009)
For the record, I'm a leading commas guy, Jeff is wrong, and it's easier to read. All you trailing comma folk need to change!:-D:-D:w00t:
BWAA-HAA!!! I was...
--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, 2009 at 10:14 am

#990478
RE: Enhancing the readability of your code: Table aliasing in sql

But in this particular SQL statement, there's no reason to alias your tables names - it would just save a few keystrokes, at the cost of making it much less...
--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 6, 2009 at 10:40 pm

#990125
RE: SET vs SELECT

aloj (5/6/2009)
SET is safer. Code below will throw an error. With select you will get a value from one of the records. Troubleshooting logic error caused by SELECT is more...
--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 6, 2009 at 10:01 pm

#990116
RE: Do You Need an IT or CS Degree to be a Successful DBA?

lcardwell (5/6/2009)
I spend a good deal of time 'splaining why certain processes/practices are important and getting folks to think 'out of the box'...
Heh... my most difficult task has been 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)

May 6, 2009 at 9:22 pm

#990109
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Manie Verster (5/6/2009)
Maybe I have an old version but doesn't matter, use any table or any string fields. This works famously. I wonder where he got the tally table idea...
--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 6, 2009 at 7:28 pm

#990091
RE: Improving data import performance - More RAM ?

ifila (5/6/2009)
I still get nulls in the Account Table 🙁
Thanks
Are all of the files you're trying to import in the exact same format and field order?
--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 6, 2009 at 5:32 pm

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

JohnG (5/4/2009)
To satisfy Jeff's curiosity...
Thanks, John.
About a year ago, I figure out how to make a strip function that manufactured the Tally table on the fly much as...
--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 5, 2009 at 9:43 pm

#989326
RE: Performance issue with tally solution

peter (5/4/2009)
Here is an update to my tally function, it has now slightly less overhead by eliminating two cross joins.
As you keenly observed before, all of these are now in...
--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 5, 2009 at 9:32 pm

#989323
RE: "tempdb" size -- 550GB!

Sorry... my bad... looking for a ROWCOUNT > 1,000,000 won't count the internal rows generated as is so typical of a cross join. Perhaps just setting the duration 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)

May 5, 2009 at 7:04 pm

#989300

Viewing 15 posts - 43,831 through 43,845 (of 59,063 total)