Forum Replies Created

Viewing 15 posts - 19,126 through 19,140 (of 59,098 total)

  • 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

  • RE: Rebuilding large index with limited free space

    ricardo_chicas (11/20/2015)

    Jeff Moden (11/17/2015)

    ricardo_chicas (11/9/2015)

    Thanks

    I will do something similar, add a new file group and move those tables over there

    What is the table used for? For example, is 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)

    November 20, 2015 at 1:17 pm

    #1841452

  • RE: High percent signal waits with very low cpu usage

    dbruton95 (11/19/2015)

    I'm investigating a problem that's kind of similar to this. Maybe you've already done this but I would suggest looking at a trace.

    We have a front...

    --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 19, 2015 at 5:21 pm

    #1841237

  • RE: Are the posted questions getting worse?

    Eirikur Eiriksson (11/19/2015)

    So to recap, here are 9 different methods for getting the current time, any additions anyone?

    😎

    SELECT

    GETDATE()

    ,SYSDATETIME()

    ,SYSDATETIMEOFFSET()

    ...

    --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 19, 2015 at 4:48 pm

    #1841232

  • RE: Good Basic T-SQL Exercises

    Ed Wagner (11/19/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 help people walk...

    --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 19, 2015 at 11:14 am

    #1841109

Viewing 15 posts - 19,126 through 19,140 (of 59,098 total)