Forum Replies Created

Viewing 15 posts - 41,596 through 41,610 (of 59,067 total)

  • RE: CPU Usage Reported By Profiler

    Chris Howarth-536003 (10/7/2009)

    We had a similar problem last year with CPU usage - when the CPU usage was high we found that Windows would randomly complain of 'insufficient resources' when...

    --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)

    October 7, 2009 at 3:05 pm

    #1063102

  • RE: SQL & the JOIN Operator

    Heh... of course, I will admit that, no matter which method someone uses to identify the column/table relationships, just about anything would be better than a format like the following...

    --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)

    October 7, 2009 at 2:21 pm

    #1063069

  • RE: A little off topic

    Wow. "Brilliant" is an understatement.

    Try the following...

    Select "Field[1]" from

    ... then find the Developer, the Manager, and the DBA that allowed the brackets and see if they like porkchops... 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)

    October 7, 2009 at 2:13 pm

    #1063062

  • RE: Are the posted questions getting worse?

    Lynn Pettis (10/7/2009)

    The last letter I got from her was dated 9/30. She said it was hard to believe that it had be 65 days already. They had...

    --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)

    October 7, 2009 at 1:49 pm

    #1063048

  • RE: SQL & the JOIN Operator

    wagner crivelini (10/7/2009)

    Hi David

    I understand your point.

    But it came out so naturally to me writing statements with aliases that it never crossed my mind to say they are optional.

    But I...

    --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)

    October 7, 2009 at 1:41 pm

    #1063045

  • RE: SQL & the JOIN Operator

    davidpenton (10/7/2009)

    The bigger concern that I have is when people *do not* use any alias, even for a simple query. Then the next person comes along, adds a join without...

    --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)

    October 7, 2009 at 1:34 pm

    #1063041

  • RE: SQL & the JOIN Operator

    David Walker-278941 (10/7/2009)

    ryan.mcatee (10/7/2009)

    Speaking of queries, the ones in the article are simple examples, but when you're pulling many columns and joining on multiple keys, repeating full table names over...

    --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)

    October 7, 2009 at 1:28 pm

    #1063040

  • RE: SQL & the JOIN Operator

    sushila (10/7/2009)

    Jeff - ...are on your way to becoming a famous author as well...could you not teach people the art of keeping an even tone..?!;-)

    Hello my long-time and trusted friend....

    --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)

    October 7, 2009 at 1:20 pm

    #1063034

  • RE: SQL & the JOIN Operator

    sql.varun (10/7/2009)

    Good Article,

    I have a question on Joins.Can anyone help me.

    When I run below query it is running for 40 mins as it is using Table Spool.

    Query:

    select a.*,b.*

    from table a

    left...

    --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)

    October 7, 2009 at 12:54 pm

    #1063015

  • RE: SQL & the JOIN Operator

    David Walker-278941 (10/7/2009)

    Jeff Moden (10/7/2009)

    Actually, they ARE becoming required. The use of table names instead of aliases has been deprecated.

    Even if they weren't, short table names may work fine...

    --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)

    October 7, 2009 at 12:51 pm

    #1063011

  • RE: Age Banding (for a beginner, please!)

    Jack Corbett (10/7/2009)

    Jeff Moden (10/5/2009)

    Proper calculation of age should never include /365.35. It also doesn't need to be complex...

    DECLARE @DOB DATETIME

    SET @DOB = '2008-03-01'

    DECLARE @Now DATETIME

    SET @Now = '2009-03-01'

    --=====...

    --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)

    October 7, 2009 at 9:24 am

    #1062867

  • RE: SQL & the JOIN Operator

    David Walker-278941 (10/7/2009)

    Yet another article that makes people think that table aliases (t1 and t2) are part of the required syntax. This first Join statement:

    SELECT t1.key1, t1.field1 as Name,...

    --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)

    October 7, 2009 at 9:12 am

    #1062855

  • RE: Difference between OPENROWSET & OPENDATASOURCE

    nigel. (10/7/2009)

    Click here

    Heh... I always get a kick out of lmgtfy.com. It's more fun than "Please visit BOL."

    --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)

    October 7, 2009 at 8:43 am

    #1062821

  • RE: Comma separated Value

    @Anitha,

    I'd still like to know why you need to do such a thing... it's just a matter of wanting to know on my part and, maybe, I (or someone else)...

    --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)

    October 7, 2009 at 8:40 am

    #1062818

  • RE: Comma separated Value

    Mark-101232 (10/7/2009)

    Matt Whitfield (10/7/2009)

    Ahh I see - interesting he didn't update the article 😀

    I see results on my boxes as being faster for 2000 & 2005 and equitable on 2008,...

    --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)

    October 7, 2009 at 8:30 am

    #1062811

Viewing 15 posts - 41,596 through 41,610 (of 59,067 total)