Forum Replies Created

Viewing 15 posts - 18,271 through 18,285 (of 59,098 total)

  • RE: How to get recursive CTE at least 3000 times faster?

    samuel.johnson (3/1/2016)

    ...since they must often be updated when new individuals are added to the records.

    How often is "often"? I ask because I have a plan.

    Also, is this for some...

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

    March 1, 2016 at 8:36 pm

    #1862266

  • RE: Report take a long time and time out

    WHug (3/1/2016)

    From what I have seen, if the report has been fast (in SSRS) and now suddenly is slow (still in SSRS) then an index has become too fragmented or...

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

    March 1, 2016 at 8:15 pm

    #1862262

  • RE: Rollback if ETL fails

    moid.hassan (3/1/2016)

    Hi,

    Need an advice on rolling back the ETL load if anything fails.

    I have a one truncate-and-load ETL process that runs every night, it first truncates the fact tables 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)

    March 1, 2016 at 7:57 pm

    #1862259

  • RE: How multiple pivot query

    TeknikServis27 (3/1/2016)

    hi steve ,

    for example

    SET LANGUAGE Turkish;

    SELECT '2016' Company , [Ocak],[1],[Subat],[2]

    FROM (

    SELECT ISNULL(st.AMOUNT, 0) AS miktar,

    DATENAME(mm, DATE_) AS ay,

    ...

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

    March 1, 2016 at 7:56 am

    #1862107

  • RE: IDEs sweet but beguiling

    xsevensinzx (2/29/2016)

    Jeff Moden (2/29/2016)

    GeorgeCopeland (2/29/2016)

    Earlier I said that professionalism can help with the easy-IDE problem. Newbie bashing is probably unprofessional.

    Is the GUI/IDE a bad thing? No, but the posers,...

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

    February 29, 2016 at 10:20 pm

    #1862008

  • RE: IDEs sweet but beguiling

    patrickmcginnis59 10839 (2/29/2016)

    Jeff Moden (2/29/2016)

    patrickmcginnis59 10839 (2/29/2016)

    Jeff Moden (2/27/2016)

    This is a really good article, Phil. It actually echoes what Bill Gates predicted back in the '80s when he said...

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

    February 29, 2016 at 5:49 pm

    #1862000

  • RE: IDEs sweet but beguiling

    GeorgeCopeland (2/29/2016)

    Earlier I said that professionalism can help with the easy-IDE problem. Newbie bashing is probably unprofessional.

    I don't consider it to be "newbie bashing" and I'll go to the wall...

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

    February 29, 2016 at 5:45 pm

    #1861999

  • RE: Deadlock help please

    gary1 (2/28/2016)

    Hi Jeff and Ed,

    I was able to get procedure name and its code (line 39). But my question is:

    1. how to find what was running in SSMS using 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)

    February 29, 2016 at 11:03 am

    #1861880

  • RE: IDEs sweet but beguiling

    patrickmcginnis59 10839 (2/29/2016)

    Jeff Moden (2/27/2016)

    This is a really good article, Phil. It actually echoes what Bill Gates predicted back in the '80s when he said that, soon, there would...

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

    February 29, 2016 at 10:41 am

    #1861873

  • RE: Deadlock help please

    gary1 (2/28/2016)

    Thank you very much Jeff,

    It's a vendor application and we don't own their code and the application update will happens through exe.

    My main worry is to find out 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)

    February 28, 2016 at 12:07 pm

    #1861697

  • RE: Insert file to sql server without front end using Stored Procedure

    Hugo Kornelis (2/28/2016)

    Before going down this path further, I urge you to read up on dynamic SQL. Here is a (lengthy but) great resource: http://www.sommarskog.se/dynamic_sql.html. If you are not aware...

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

    February 28, 2016 at 8:47 am

    #1861692

  • RE: CAST tinyint to nvarchar

    Ed Wagner (2/26/2016)

    Yeah, I tend to go with a very literal interpretation. As has been pointed out, a simple Error in the table would have helped. I can...

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

    February 28, 2016 at 7:55 am

    #1861691

  • RE: Deadlock help please

    gary1 (2/27/2016)

    Thanks Jeff,

    I was not running any queries in SSMS. We were running bunch of sql scripts which will do some updates (it's a vendor application, will get an...

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

    February 28, 2016 at 7:45 am

    #1861689

  • RE: The Dangers of Algorithms

    Outstanding article, Steve. I'd discuss it a bit more but, being a customer/consumer of software, I would tick off the whole world with my thoughts in this area, so...

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

    February 27, 2016 at 7:34 pm

    #1861668

  • RE: Converting VARCHAR to BIGINT

    Luis Cazares (2/27/2016)

    Jeff Moden (2/25/2016)

    Luis Cazares (2/25/2016)

    If by any chance you're working with SQL Server 2012 or later, you can use TRY_CAST or TRY_CONVERT.

    Have you compared it for performance?

    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)

    February 27, 2016 at 6:37 pm

    #1861667

Viewing 15 posts - 18,271 through 18,285 (of 59,098 total)