Jeff Moden

Forum Replies Created

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

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
RE: Eliminating Cursors

Pierre Boucher (6/16/2008)
Those tests consists of calculating the running total for one field in the table. Both versions does exactly the same thing.
Right up my alley... no need 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)

June 16, 2008 at 2:37 pm

#829492
RE: Using VBA to pull SQL data into Excel?

Crud... Matt beat me to it... 🙂
--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:33 pm

#829489
RE: Using VBA to pull SQL data into Excel?

rbarryyoung (6/16/2008)
Jeff Moden (6/16/2008)
rbarryyoung (6/16/2008)
Jeff Moden (6/15/2008)
rbarryyoung (6/15/2008)
On the other hand, if your sheets need to be resized based on the number of rows returned, then automated "Get External Data"...
--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:29 pm

#829486

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