Forum Replies Created

Viewing 15 posts - 17,851 through 17,865 (of 59,098 total)

  • 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

  • RE: How does SQL detect if a database backup was done?

    Here's what I'm talking about... this checks to find out what the current recovery model is so that you can make better decisions as to what kind of backup 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 17, 2016 at 12:38 pm

    #1872619

Viewing 15 posts - 17,851 through 17,865 (of 59,098 total)