Forum Replies Created

Viewing 15 posts - 18,871 through 18,885 (of 59,098 total)

  • RE: LEAP and LAG behind the scenes

    Jason A. Long (12/23/2015)

    This is just a quick test... But according to this, the Windowed SUM is going faster... see what you think...

    You've fallen into the same trap that half...

    --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 23, 2015 at 5:45 pm

    #1847862

  • RE: How to reduce Huge Log File size

    ScottPletcher (12/23/2015)

    Jeff Moden (12/22/2015)

    WhiteLotus (12/21/2015)

    Sounds good ..I also notice that all databases autogrowth option are 10% . Should I change all of them ?

    If the initial size was 1MB, 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)

    December 23, 2015 at 4:42 pm

    #1847859

  • RE: will full backup break log shipping

    PearlJammer1 (12/23/2015)

    Thanks very much. For some reason where I work they are saying that in the past backups have broken things...not sure what they have been doing historically.

    Thanks for confirmation...

    --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 23, 2015 at 4:36 pm

    #1847857

  • RE: Changing the column name dynamically

    twin.devil (12/22/2015)

    Jeff you are right about the actual root cause thing but sometimes OP required the only one thing which is missing from the puzzle. i-e OP have already done...

    --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 23, 2015 at 11:53 am

    #1847826

  • RE: Are the posted questions getting worse?

    Ed Wagner (12/22/2015)

    Michael L John (12/22/2015)

    Phil Parkin (12/22/2015)

    It seems that everyone in this thread spends their spare time shooting things :exclamationmark::-D

    It's better stress relief than choking developers.

    I find that 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 23, 2015 at 11:20 am

    #1847815

  • RE: LEAP and LAG behind the scenes

    J Livingston SQL (12/23/2015)

    Jeff Moden (12/23/2015)

    I don't know what goes on behind the scenes but I do know that, whatever they did, it makes for relatively slow running totals. :crazy:

    Jeff...if...

    --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 23, 2015 at 10:41 am

    #1847806

  • RE: Another Recursive Hierarchy bit of help needed...

    Jason A. Long (12/22/2015)

    Yea... I'm right there with you. My latest test harness was based solely on my perception of what Jeff was talking about. I'm not certain that it's...

    --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 23, 2015 at 8:45 am

    #1847780

  • RE: LEAP and LAG behind the scenes

    I don't know what goes on behind the scenes but I do know that, whatever they did, it makes for relatively slow running totals. :crazy:

    --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 23, 2015 at 8:27 am

    #1847768

  • RE: Datetime2

    Early Christmas gift... thanks Steve.

    Shifting gears to one of my "favorite" rants...

    Heh... if you use DATETIME2(3), you get approximately the same precision as DATETIME (3.3 milliseconds rounded to the nearest...

    --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 23, 2015 at 8:24 am

    #1847766

  • RE: SQL server slowdown by increasing processors?

    awarnke 39611 (12/22/2015)

    I'd go back and rewrite the queries, but that would be a huge undertaking for a system we are moving towards obsolescence. We'll continue to dig...

    --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 22, 2015 at 6:51 pm

    #1847629

  • RE: Database Stuck in Restore Mode

    itguy2015 (12/22/2015)

    I have a similar situation. I had a database "mydb" on a sql server instance on vm1. I also had mydb on a sql server instance on...

    --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 22, 2015 at 6:47 pm

    #1847628

  • RE: CLR Yes or no?

    That might be a decent use but it really depends on how the CLR is written. My suggestion would be to test it for performance in a Dev environment...

    --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 22, 2015 at 6:01 pm

    #1847625

  • RE: How to reduce Huge Log File size

    WhiteLotus (12/21/2015)

    Sounds good ..I also notice that all databases autogrowth option are 10% . Should I change all of them ?

    If the initial size was 1MB, it takes 73 growths...

    --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 22, 2015 at 4:55 pm

    #1847618

  • RE: Changing the column name dynamically

    koti.raavi (12/21/2015)

    Hi All,

    Below is the sample query

    Select Month1,Month2,Month3......Month24 from #temp

    I need to display data like below

    Select Month1 as [Dec 2015], Month2 as [Jan 2016],Month3 as [Feb 2016] From...

    --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 22, 2015 at 4:12 pm

    #1847614

  • RE: Many individual inserts hitting one CPU core

    I know it's going to sound crazy but it sounds like a network cable, NIC, or Switch/Hub port may have gone bad. It could also be that some genius...

    --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 22, 2015 at 3:49 pm

    #1847608

Viewing 15 posts - 18,871 through 18,885 (of 59,098 total)