Jeff Moden

Forum Replies Created

Viewing 15 posts - 49,996 through 50,010 (of 59,102 total)

RE: Non-Sequential Insertion of Data from Temp Table or Arraylist Structure From Within Nested Loop - Inserting Values into Related Tables with Identity Key, CLR or CTE Needed

Tech_Newbie (6/16/2008)
Lets say You have 100 seperate lists of a range of 25-50 people each. For the purpose of inputting the data, you compile all people into one list, organized...
--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)

June 16, 2008 at 10:34 pm

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

Thanks, Navket... I appreciate the feedback.
If you really want to see something that replaces the loop or a cursor, take a look at the following...
http://www.sqlservercentral.com/articles/Advanced+Querying/61716/
--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)

June 16, 2008 at 10:04 pm

#829590
RE: Parse delimited data in column to multiple columns

Stephanie Giovannini (6/16/2008)
Outstanding job, Stephanie! 🙂
--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)

June 16, 2008 at 9:58 pm

#829588
RE: Do You Want to Be Right?

GSquared (6/16/2008)
I have some examples where hardware was a solution. See if you agree with them:
Yes... we did something similar at work... we changed from SQL Server Standard Edition...
--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)

June 16, 2008 at 9:38 pm

#829586
RE: CLR Table-valued function

HYDNIZ (6/16/2008)
The other thing I can add is the array manipulation. I made my mathematical calculations from an array. I can use CLR from either .net program or part of...
--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)

June 16, 2008 at 9:27 pm

#829583
RE: Concatenate Results Into A Single Field

Outstanding... thanks for the feedback, Matt. And, I'm sorry... I didn't realize that you were already beating the distinct drum on the usage of the function...
--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)

June 16, 2008 at 9:10 pm

#829579
RE: Presentation tips

Basically, explain what you did here and expound upon how this technique can be applied elsewhere... you will be successful...
http://www.sqlservercentral.com/Forums/Topic511356-61-1.aspx
--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)

June 16, 2008 at 9:07 pm

#829578
RE: Presentation tips

karthikeyan (6/16/2008)
I have to give a presentation to my manager, my manager's manager, again, his manager ( upto 3 level) over my tuning work tomorrow.
What have you done 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)

June 16, 2008 at 9:04 pm

#829577
RE: Eliminating Cursors

TheSQLGuru (6/16/2008)
Jeff, I have referenced the Running Totals thread at least 10 times now on various MS forums, including the MVP private one.
Thank you for the awesome honor,...
--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)

June 16, 2008 at 8:56 pm

#829574
RE: Concatenate Results Into A Single Field

Ummmm.... sorry Matt... the function is not written correctly and it has not been called correctly. The function has two extra SET statements which slows it down and 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)

June 16, 2008 at 8:41 pm

#829570
RE: Eliminating Cursors

Pierre Boucher (6/16/2008)
So, if you see my resume at your company, I will deny ever writing that code :ermm:
Pierre... I think I like your attitude... alot!:)
--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)

June 16, 2008 at 8:06 pm

#829567
RE: Concatenate Results Into A Single Field

Matt Miller (6/16/2008)
Jeff Moden (6/16/2008)
jcrawf02 (6/16/2008)
...you should just run sp_ASPCA and solve the problem
Heh... I've found that it also works great on some developers 😀
You can try that, 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)

June 16, 2008 at 2:50 pm

#829503
RE: Eliminating Cursors

Heh... cool... I finally beat Mr. Miller at a response... 😛
--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)

June 16, 2008 at 2:47 pm

#829501
RE: Concatenate Results Into A Single Field

adi.cohen (6/16/2008)
Ohh... got me a litle confused..... I didn't notice I'm publishing in 2k forum, just saw this now (after you paid my attension to this).
I'm realy sorry for this...
--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)

June 16, 2008 at 2:42 pm

#829497
RE: Concatenate Results Into A Single Field

jcrawf02 (6/16/2008)
...you should just run sp_ASPCA and solve the problem
Heh... I've found that it also works great on some developers 😀
--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)

June 16, 2008 at 2:40 pm

#829495

Viewing 15 posts - 49,996 through 50,010 (of 59,102 total)