Forum Replies Created

Viewing 15 posts - 19,096 through 19,110 (of 59,072 total)

  • RE: Pivot One Row Field for All Rows Containing Same Time

    o324712 (11/22/2015)

    All data you would need is there. I don't have any DDL's as this is a sample. The original table if I had one would be the first 5...

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

    November 22, 2015 at 9:17 am

    #1841557

  • RE: Find Tables That Should Have Indexes ?

    homebrew01 (11/21/2015)

    I found a table that should have had some indexes to improve performance. So now I'm wondering what other tables could benefit. I can get a list of tables...

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

    November 21, 2015 at 5:33 pm

    #1841540

  • RE: Copy of 1 TB prod database

    tripleAxe (11/18/2015)

    In my experience backup time was significantly reduced. I had a 1TB database that was taking 5 hours to backup. Changed the backup to stripe to 8...

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

    November 21, 2015 at 5:12 pm

    #1841538

  • RE: Identifying Rock/Paper/Scissors Scenarios

    jmpatchak (11/20/2015)

    Hi Alan,

    This does a really great job of generating random test data. What I'm looking for is a query that pulls out the data from the Battle table that...

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

    November 21, 2015 at 5:05 pm

    #1841537

  • RE: Testing Potential Candidates

    Ed Wagner (11/21/2015)

    I think HR being the first interview is simply to get the housekeeping questions out of the way. These are things like determining if the person 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)

    November 21, 2015 at 4:36 pm

    #1841536

  • RE: Good Basic T-SQL Exercises

    Steve Jones - SSC Editor (11/21/2015)

    you guys are killing me with questions and not t-sql problems. :w00t:

    That's because T-SQL isn't a problem. 😛

    I think we need to get a couple...

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

    November 21, 2015 at 3:54 pm

    #1841534

  • RE: Alternative Way to Parse JSON String?

    omegadev21 (11/21/2015)

    @jeff: Thanks for this. I will run this by our DBA when I get in the office on Monday, meanwhile I'll implement in my test environment at home...

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

    November 21, 2015 at 2:55 pm

    #1841532

  • RE: Good Basic T-SQL Exercises

    Steve Jones - SSC Editor (11/21/2015)

    Jeff Moden (11/19/2015)

    Steve Jones - SSC Editor (11/19/2015)

    Here, though not sure how/why/when. I am trying to get some POC together that could be used to...

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

    November 21, 2015 at 2:53 pm

    #1841531

  • RE: Alternative Way to Parse JSON String?

    Ok... caught a break from work.

    Here's a two row test table. This is NOT a part of the solution. It's just a test table to show the possibilities....

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

    November 21, 2015 at 1:55 pm

    #1841527

  • RE: Alternative Way to Parse JSON String?

    omegadev21 (11/20/2015)

    Alan.B (11/20/2015)

    omegadev21 (11/20/2015)

    Jeff Moden (11/20/2015)

    Ah... maybe I missed it. Is this the data example?

    Given the field CLIENT_DATA of data type VARCHAR(MAX) with data:

    {"LASTNAME":"Doe","FIRSTNAME":"John","EMAILADDRESS":"something@email.com","USERNAME":"exusername","PHONENUMBER":"15555555555"}

    @jeff Moden, yeah that's the sample...

    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)

    November 21, 2015 at 5:57 am

    #1841511

  • RE: Alternative Way to Parse JSON String?

    Ah... maybe I missed it. Is this the data example?

    Given the field CLIENT_DATA of data type VARCHAR(MAX) with data:

    {"LASTNAME":"Doe","FIRSTNAME":"John","EMAILADDRESS":"something@email.com","USERNAME":"exusername","PHONENUMBER":"15555555555"}

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

    November 20, 2015 at 9:51 pm

    #1841492

  • RE: Alternative Way to Parse JSON String?

    omegadev21 (11/20/2015)

    I know there are JSON parsers out there, but I'm hoping to avoid using a separate function as the query is being built using a builder in a C++...

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

    November 20, 2015 at 9:45 pm

    #1841491

  • RE: Alternative Way to Parse JSON String?

    I have a far better idea...

    Drive to the building where the person who sent you the hierarchical, denormalized crap and beat the hell out of them for being so stupid....

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

    November 20, 2015 at 9:28 pm

    #1841490

  • RE: Pieces of SQL code stored in table

    RVO (11/20/2015)

    I inherited this ETL process from guys who designed it 2 years ago.

    It will be replaced by JAVA solution in 2016.

    It'll be interesting to see how that works out....

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

    November 20, 2015 at 3:00 pm

    #1841471

  • RE: Early Adopters

    I learned NOT to be an early adopter of anything long before I started working with SQL Server. After seeing things like 2000 SP3, 2005 RTM, 2008, 2012 RTM,...

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

    November 20, 2015 at 2:51 pm

    #1841469

Viewing 15 posts - 19,096 through 19,110 (of 59,072 total)