Forum Replies Created

Viewing 15 posts - 16,036 through 16,050 (of 59,067 total)

  • RE: Parsing paired relationships.

    Jason A. Long (12/23/2016)

    @jeff - It looks to be the result of some sort of matching process, where A was matched to B and B was matched to A... Resulting...

    --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, 2016 at 8:18 pm

    #1919573

  • RE: Parsing paired relationships.

    Hmmm... looking at the original small list of nodes in the original post, there might just be a way to Ferret out the root nodes. I'll give that 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 23, 2016 at 5:59 pm

    #1919571

  • RE: Parsing paired relationships.

    Jason A. Long (12/23/2016)

    @jeff - It looks to be the result of some sort of matching process, where A was matched to B and B was matched to A... Resulting...

    --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, 2016 at 5:31 pm

    #1919570

  • RE: Parsing paired relationships.

    @richard-2.gardner,

    I'm still playing with the data but let me make a suggestion.

    The data you currently have is the result of someone creating the "opposite direction" node for every node in...

    --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, 2016 at 1:16 pm

    #1919559

  • RE: How to troubleshoot sudden drop in Page Life Expectancy?

    SQL Guy 1 (12/23/2016)

    Jeff Moden (12/22/2016)

    but the only time I truly concern myself with a vertical drop with PLE is if it drops and stays there for an uncomfortable...

    --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, 2016 at 1:10 pm

    #1919558

  • RE: How to troubleshoot sudden drop in Page Life Expectancy?

    SQL Guy 1 (12/22/2016)

    I would agree if that was a small drop, for example from 3000 to 2000 sec. But a drop from 3000 to 100 sec I understand...

    --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, 2016 at 6:08 pm

    #1919458

  • RE: Bulk Insert vs. BCP Utility

    smatu (12/22/2016)

    What is the difference between Bulk Insert and BCP.

    Which will be most effective in importing a bulk of data from flat file into sql server database?

    Do both exist...

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

    #1919457

  • RE: Help with delimited SQL

    Phil Parkin (12/22/2016)

    nadersam (12/22/2016)

    Hi Guys,

    I am trying to execute an array of comma delimited SQLs in a stored procedure.

    I call it as below

    declare @Parameter as nvarchar(max)

    set @Parameter ='insert into...

    --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, 2016 at 4:26 pm

    #1919452

  • RE: BIGINT TO INT - CAN i DO IT?

    Just curious... which language is the frontend code written in?

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

    #1919451

  • RE: How to troubleshoot sudden drop in Page Life Expectancy?

    I'll suggest that it's almost a waste of time. It's certainly an indication that something wasn't in memory when it was needed but that's not necessarily a problem especially...

    --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, 2016 at 3:32 pm

    #1919443

  • RE: Today's Random Word!

    Ed Wagner (12/22/2016)

    Manic Star (12/22/2016)

    djj (12/22/2016)

    aPed001 (12/22/2016)

    Stuart Davies (12/22/2016)

    DamianC (12/22/2016)

    Ed Wagner (12/20/2016)

    Manic Star (12/20/2016)

    Grumpy DBA (12/20/2016)

    ZZartin (12/20/2016)

    Ed Wagner (12/20/2016)

    Revenant (12/20/2016)

    djj (12/20/2016)

    Ed Wagner (12/20/2016)

    Hugo Kornelis (12/20/2016)

    Manic Star (12/20/2016)

    Power

    People

    Users

    Administrator

    Access

    Permissions

    word

    Excel

    Mediocre

    Accepted

    part

    Exchange

    Stock

    Pot

    Chicken (not Dino)

    Fried

    Brain

    --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, 2016 at 3:29 pm

    #1919442

  • RE: Parsing paired relationships.

    richard.gardner 6009 (12/22/2016)

    Hi Jeff,

    Here's a sample dataset, my bad, 89,000 is a different number, it's just 50,000 pairs of internal keys.

    @chris-2 - Thanks for the offer, appreciated, I'll have...

    --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, 2016 at 1:56 pm

    #1919426

  • RE: GROUP BY in SQL Server 2014

    patrickmcginnis59 10839 (12/22/2016)

    Jeff Moden (12/21/2016)

    CELKO (12/14/2016)

    The order by clause converts the set into a cursor. A cursor is a sequential file structure, which does have an ordering.

    No, Sir. 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 22, 2016 at 1:48 pm

    #1919425

  • RE: GROUP BY in SQL Server 2014

    Sergiy (12/21/2016)

    The source of the error is here:

    EXEC sys.sp_spaceused @objname = N'dbo.Tally'

    3.6 kb - single page.

    Which means there is no actual Index seek, it's full table scan for any query...

    --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, 2016 at 7:36 am

    #1919331

  • RE: GROUP BY in SQL Server 2014

    CELKO (12/14/2016)

    The order by clause converts the set into a cursor. A cursor is a sequential file structure, which does have an ordering.

    No, Sir. I know what you're trying...

    --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 21, 2016 at 8:44 pm

    #1919259

Viewing 15 posts - 16,036 through 16,050 (of 59,067 total)