Jeff Moden

Forum Replies Created

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

RE: Deleting batches of rows with TOP

Ted Pin (7/3/2008)
@jeff:
Thanks for your feedback. I will try to create a more well thought-out article for my next submission based on the comments in this discussion. I looked around...
--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 8:10 am

#837878
RE: An MVP From Way Down South

Yee-hah! Now we're cooking! You were one of the folks I thought of when I said "there's a lot of MVP's in the making on this forum". ...
--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 7:19 am

#837819
RE: Deleting batches of rows with TOP

GermanDBA (7/3/2008)
Also, would this not be even better using a numbers table á la Jeff Moden http://www.sqlservercentral.com/articles/TSQL/62867/ ?
Thank you for the reference... but the Tally table isn't a panacea for...
--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 7:08 am

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

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