Forum Replies Created

Viewing 15 posts - 17,821 through 17,835 (of 59,069 total)

  • RE: Unattended Installation

    Raghavender (4/19/2016)

    I am not sure whether we can modify the published one.

    @admin-2: Please help here.

    Just submit a correct copy with text in place of pictures the same way...

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

    April 20, 2016 at 9:05 pm

    #1873500

  • RE: Building BI from Scratch!

    singhamitpal (4/19/2016)

    I have spoke to some people who claim themselves to be SQL Guru's. Anyways, below is what I found...

    1.Very few developers will be able to create a consistent stored...

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

    April 20, 2016 at 8:59 pm

    #1873499

  • RE: Sargible cases for Cast,Convert, and RTRIM

    Sergiy (4/20/2016)

    MadAdmin (4/19/2016)

    Select businessentityid from person.person where rtrim(lastname) like 'Smith%' --108 Reads What is happening here?

    Select businessentityid from person.person where rtrim(lastname) like @var --4 Reads What is happening here?

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

    April 20, 2016 at 7:19 pm

    #1873492

  • RE: More GROUP BY

    Joel Ewald (3/24/2016)

    I think with the current data model and lack of constraints you would actually want both.

    WHERE Played = 'Rock' OR Played = 'Paper' OR Played = 'Scissors'

    GROUP BY...

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

    April 20, 2016 at 6:57 am

    #1873306

  • RE: More GROUP BY

    l.vignando (3/24/2016)

    Nice question, but awarding points for and titling "Group by" is a big hint, so alternatives without group should be automatically excluded.

    By the same token, a whole lot 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)

    April 20, 2016 at 6:52 am

    #1873302

  • RE: How to avoid locking/ daed locking while altering table

    Ken McKelvey (4/19/2016)

    An alternative would be be have an XML column in the base table where user defined fields could be placed. This would give you the option to use...

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

    April 19, 2016 at 9:22 am

    #1873101

  • RE: Loading files in parallel

    Phil Parkin (4/19/2016)

    richardmgreen1 (4/19/2016)

    Thanks for that Jeff.

    I'll have a chat with the SAN admins and see where our drives are sat.

    While that will provide useful background info, this situation is...

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

    April 19, 2016 at 8:14 am

    #1873078

  • RE: Please help me improve the performance of this query

    Mike Frazer (4/14/2016)

    Thank you...attached.

    Edit: I added the DDL for the related objects as scripts.txt

    I looked for the 68% cost node in the execution plan and I'm not finding 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)

    April 18, 2016 at 7:35 pm

    #1872932

  • RE: Please help me improve the performance of this query

    Good discussion but still off the rails. Anyone going to help the OP? 😉

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

    April 18, 2016 at 7:06 pm

    #1872929

  • RE: BULK INSERT seems not to recognise line terminators

    Mark Dalley (4/18/2016)

    Just for the record, why doesn't the backslash n after the fifth field in the format file show up, (unless one sticks a space between the backslash and...

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

    April 18, 2016 at 7:03 pm

    #1872928

  • RE: Where is my backup?

    dxu (4/18/2016)

    Hi Jeff,

    Thanks for your reply.

    The full back up normally take over than an hour. For example full backup start on 1AM, and finish around 2:30AM. The log...

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

    April 18, 2016 at 7:01 pm

    #1872927

  • RE: How to avoid Data Purging?

    sram24_mca (12/2/2015)

    If we are not running the data purge script, then the server is too slow and affecting the performance as well.

    Regards,

    Ram

    The server runs fine. It's the code...

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

    April 18, 2016 at 6:38 pm

    #1872926

  • RE: What's Your Downtime?

    Steve Jones - SSC Editor (4/18/2016)

    Jeff Moden (4/15/2016)

    Steve Jones - SSC Editor (4/15/2016)

    I'd hope a cloud provider wouldn't have this happen and would have plans for multiple redundancies 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)

    April 18, 2016 at 11:39 am

    #1872852

  • RE: Loading files in parallel

    richardmgreen1 (4/18/2016)

    @frederico - we did have a think about the load balancing option by using some sort of load table to pick up the next available file but couldn't quite...

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

    April 18, 2016 at 9:42 am

    #1872805

  • RE: Where is my backup?

    dxu (4/17/2016)

    Thanks guys. I think I was correct. I change the full backup to start on 1:30AM everyday and log backup to run every two hours start on 3AM. 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)

    April 18, 2016 at 9:40 am

    #1872803

Viewing 15 posts - 17,821 through 17,835 (of 59,069 total)