Jeff Moden

Forum Replies Created

Viewing 15 posts - 52,591 through 52,605 (of 59,098 total)

RE: Performance Tuning: Concatenation Functions and Some Tuning Myths

Ian Crandell (1/9/2008)
Jeff Moden (1/8/2008)
We've actually put some "documentation standards" into play at work. They're not so limiting as to suppress innovation, but they do state what must be...
--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)

February 12, 2008 at 10:27 pm

#777680
RE: SQL task & @@IDENTITY

Heh... one of the many reasons I don't use DTS...
--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)

February 12, 2008 at 9:48 pm

#777676
RE: Datatype for US Money

I've used Money... I've used SmallMoney... I've even used Decimal... and they all failed the accuracy test when it came to things like mortgage calculations.
If all you're ever going 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)

February 12, 2008 at 9:42 pm

#777675
RE: Measuring performance on database/tables

Yes... it does make a difference... about 21% without an order by and about 12% with an order by. But wait...
Heh... on a million rows of data with...
--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)

February 12, 2008 at 9:18 pm

#777670
RE: How do I add quarter to my dates table

Nuts (2/12/2008)
That exactly what I wanted
Just curious... which way did you end up going exactly?
--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)

February 12, 2008 at 8:38 pm

#777667
RE: Concatenate numbers to form a 7 digit string

stricknyn (2/12/2008)
Hello,
Seems like this should be pretty straight forward, but its not working. I'm trying to build a string with 7 characters from a random statement:
Declare @mn int
Declare @mx...
--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)

February 12, 2008 at 8:36 pm

#777666
RE: Concatenate numbers to form a 7 digit string

I'm confused... I believe the cross-join is to generate a million rows... not to generate the 7 digits. Perhaps I was looking at the wrong post. Which one...
--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)

February 12, 2008 at 8:27 pm

#777663
RE: Concatenate numbers to form a 7 digit string

Michael Valentine Jones (2/12/2008)
John Beggs (2/12/2008)
I think you'll find that the difference between 1ms and 1ms is pretty negligible. Feel free to test for yourself.
What boundary would you set...
--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)

February 12, 2008 at 5:52 pm

#777647
RE: View running slow. Any issues with this query?

Heh... proof again... performance is in the code... water cooled CPU's wouldn't have made that query run any faster.
Nice job, Matt.
--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)

February 12, 2008 at 5:48 pm

#777645
RE: Extract Issue (".0" added to values)

Previews lie... not sure I'd take 100% stock in the preview any more than the trust I put in an estimated execution plan (which I don't trust at all ;)...
--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)

February 12, 2008 at 5:39 pm

#777644
RE: TSQL: Computing Balance

Heh... correct... there's always that "one time" that justifies the cold water you have running through the garden hose to baseplate of the CPU in your server 😉
--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)

February 12, 2008 at 5:36 pm

#777643
RE: Compare two Identical tables

Lookup_BI (2/12/2008)
but despite many suggestions..My boss[:alien:] is still sticking with his decision.
Crud... I've been there and done that... having a boss that wears a big ol' chip on his shoulder...
Sure...
--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)

February 12, 2008 at 5:29 pm

#777642
RE: Combine 2 Text Fields??

Heh... perfect...
--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)

February 12, 2008 at 5:24 pm

#777641
RE: Help with formating

Greg,
Would you post one of your emails that has the correct format, please? Be sure to use a code window (Click on "IFCode" in the menu of the edit...
--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)

February 12, 2008 at 4:53 pm

#777637
RE: TSQL: Computing Balance

antonio.collins (2/12/2008)
this particular example is not a pure triangle as illustrated in your article. that's because the 'code' (account number) is used as the primary join article. so,...
--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)

February 12, 2008 at 9:58 am

#777411

Viewing 15 posts - 52,591 through 52,605 (of 59,098 total)