Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,486 through 49,500 (of 59,099 total)

RE: Handling hirarchy in tables

rashmi.todkar (7/3/2008)
hey all thanks for your replies.
By the way... you still owe us some replies so we can help... like my question about "How often will the data in 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)

July 3, 2008 at 5:48 am

#837753
RE: Handling hirarchy in tables

rashmi.todkar (7/3/2008)
hey what is nested table hierarchy.. can you guys help me in finding out.
This link explains...
http://www.ibase.ru/devinfo/DBMSTrees/sqltrees.html
--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)

July 3, 2008 at 5:46 am

#837749
RE: Congratulations to Our New MVPs

I got the "E" ticket... I'll be there the whole time...
--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)

July 3, 2008 at 5:43 am

#837743
RE: Bulk Insert and Index Considerations

In this case... maybe/probably nothing...
Just so you know about the logging, BCP will be logged if there are indexes on the perm table so it won't make a difference...
--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)

July 2, 2008 at 8:46 pm

#837579
RE: Congratulations to Our New MVPs

rbarryyoung (7/2/2008)
Jeff Moden (7/2/2008)
ALZDBA (7/2/2008)
Congratulations Jeff and Michael.
A virtual pint to your honor ! (maybe we'll materialize that at SQLPass 😀 )
We can do that! I'll actually be at...
--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)

July 2, 2008 at 8:29 pm

#837571
RE: Congratulations to Our New MVPs

Vivien Xing (7/2/2008)
Congratulations to both of you.
I am really impressed by Jeff’s posts. Seems nothing he cannot resolve. When I post my question, I wish Jeff...
--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)

July 2, 2008 at 8:28 pm

#837569
RE: Congratulations to Our New MVPs

Mike C (7/2/2008)
I hear drinks are on Jeff? 🙂
Only if you get real clumsy 😀
--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)

July 2, 2008 at 8:23 pm

#837566
RE: Replace non numeric characters in string

Peter E. Kierstead (7/2/2008)
Yes, every technique has its achilles heel... one of the CTE's is the recursion level...
But this works great for most things I used to use WHILE loops...
--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)

July 2, 2008 at 4:27 pm

#837540
RE: Bulk Insert and Index Considerations

Toby White (6/27/2008)
I am doing a bulk insert of 132,873,975 rows that are ordered by zip code. The receiving table has 2 indexes on it and a 3rd possible clustered...
--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)

July 2, 2008 at 4:16 pm

#837538
RE: Bulk Insert and Index Considerations

John Rowan (7/2/2008)
Not trying to be obtuse, but can you expand on this a bit Jeff? What issues are there with BCPing directly into the final table? 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)

July 2, 2008 at 4:09 pm

#837536
RE: Bulk Insert and Index Considerations

noeld (7/2/2008)
I think Jeff is reffering to ALTER TABLE SWITCH ... for partitioned tables
Not what I was referring to... some folks just feel that they've gotta put an index 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)

July 2, 2008 at 3:32 pm

#837528
RE: Bulk Insert and Index Considerations

John Rowan (7/2/2008)
Not trying to be obtuse, but can you expand on this a bit Jeff? What issues are there with BCPing directly into the final table? 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)

July 2, 2008 at 3:20 pm

#837526
RE: Replace non numeric characters in string

Peter E. Kierstead (7/2/2008)
Ok... no WHILE loop, no TALLY table...
Declare @OldStr VarChar(max),@NewStr VarChar(max);
Select @NewStr='',@OldStr='ab123c';
With NumOnly as
(
Select Case when SubString(@OldStr,1,1) like '[0-9]' then SubString(@OldStr,1,1) else '' End[Chr],1[Idx]
Union All
Select Case when SubString(@OldStr,Idx+1,1)...
--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)

July 2, 2008 at 3:05 pm

#837518
RE: Non sargable mightmare

GSquared (7/2/2008)
cast a curse of impotence on the original coder and all his descendants for a thousand generations
Ummmm... isn't THAT a bit of an oxymoron? 😀
--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)

July 2, 2008 at 3:02 pm

#837516
RE: Congratulations to Our New MVPs

Grant Fritchey (7/2/2008)
You're going to be at PASS?
You've got a beverage-of-your-choice coming from me. Track me down.
Track you down? Heh... I'm putting my Avatar on the back of 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)

July 2, 2008 at 2:59 pm

#837515

Viewing 15 posts - 49,486 through 49,500 (of 59,099 total)