Forum Replies Created

Viewing 15 posts - 18,841 through 18,855 (of 59,098 total)

  • RE: How to reduce Huge Log File size

    ScottPletcher (12/25/2015)

    Jeff Moden (12/24/2015)

    You've confused me a bit, Scott. First you say that 16 VLFs for a 1GB logfile is too low and then you explain using even fewer...

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

    December 25, 2015 at 1:43 pm

    #1848072

  • RE: The Most Common Query Blunders...

    I believe my favorite non-SARGable problems are due to the inappropriate use of "OR" and things like the following...

    WHERE ISNULL(SomeNumericColumn,0) > 0

    ...

    WHERE ISNULL(SomeCharacterColumn,' ') > '...

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

    December 25, 2015 at 1:37 pm

    #1848071

  • RE: LEAP and LAG behind the scenes

    Jason A. Long (12/25/2015)

    Jeff Moden (12/25/2015)

    Jason A. Long (12/25/2015)

    Come to think of it, I had planned to write an article about creating an insanely fast "Working Days" iTVF I built...

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

    December 25, 2015 at 1:24 pm

    #1848067

  • RE: The Most Common Query Blunders...

    Jason A. Long (12/25/2015)

    Jeff Moden (12/25/2015)

    Here's one thing that you should talk about... not subscribing to the absolute belief in "best practices" even if millions of people subscribe to a...

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

    December 25, 2015 at 1:15 pm

    #1848063

  • RE: The Most Common Query Blunders...

    Jason A. Long (12/25/2015)

    Ed Wagner (12/25/2015)

    This certainy isn't a comprehensive list, but I think it's a decent start.

    While loops or cursors instead of set-based alternatives

    Non-SARGable predicates

    Multi statement table valued functions

    Using...

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

    December 25, 2015 at 12:44 pm

    #1848057

  • RE: The Most Common Query Blunders...

    Jason A. Long (12/25/2015)

    Ed Wagner (12/25/2015)

    This certainy isn't a comprehensive list, but I think it's a decent start.

    While loops or cursors instead of set-based alternatives

    Non-SARGable predicates

    Multi statement table valued functions

    Using...

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

    December 25, 2015 at 12:41 pm

    #1848055

  • RE: An Impressive SQL Server

    Ed Wagner (12/25/2015)

    Anders Pedersen (12/25/2015)

    Since the article was reposted...

    Two of the largest credit charge clearing systems runs on SQL, and has for a long time. The first time 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)

    December 25, 2015 at 12:24 pm

    #1848050

  • RE: Number VS Letter

    Basurmanin (12/25/2015)

    take it easy

    First, I agree... as frustrating as questions with seemingly unwarranted restrictions go, people need to "Take it Easy".

    You can help diffuse such responses. People...

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

    December 25, 2015 at 11:45 am

    #1848046

  • RE: LEAP and LAG behind the scenes

    Jason A. Long (12/25/2015)

    Come to think of it, I had planned to write an article about creating an insanely fast "Working Days" iTVF I built a few months back...

    Now THAT...

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

    December 25, 2015 at 11:18 am

    #1848045

  • RE: The Most Common Query Blunders...

    Ed Wagner (12/25/2015)

    Kevin, just the way you phrased "bad-data causers" made me think of the horrible offense of storing dates and times in string columns.

    Or, like MS did in MSDB,...

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

    December 25, 2015 at 11:08 am

    #1848041

  • RE: Best way to merge two large client databases

    It's most likely because I've never had to do such a thing but I don't know of any tool designed to do something like this. There are tools like...

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

    December 24, 2015 at 7:58 pm

    #1848008

  • RE: Best way to merge two large client databases

    titsiros (12/23/2015)

    Yes

    It's going to a bugger then. One of the two client's IDs are all going to have to change and you'll need to ensure that reference tables are...

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

    December 24, 2015 at 6:11 pm

    #1848005

  • RE: Cursor or special select statement?

    Wouldn't a CASE statement do the trick here?

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

    December 24, 2015 at 6:05 pm

    #1848004

  • RE: How to use 'like' in a query

    SQLisAwE5OmE (12/24/2015)

    Yes, it's giving me all activities between 11/30 to 12/1.

    Correct?

    Technically, not correct especially since "BETWEEN" in T-SQL is inclusive of both end values.

    Scott's code giving you all activities...

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

    December 24, 2015 at 4:40 pm

    #1848002

  • RE: Difference Between cross apply and cross join

    RonKyle (12/24/2015)

    That's a pretty jerk answer.

    Sorry, but I don't agree. Maybe it could have been phrased differently, although I don't see anything wrong with it. 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)

    December 24, 2015 at 4:27 pm

    #1848001

Viewing 15 posts - 18,841 through 18,855 (of 59,098 total)