Forum Replies Created

Viewing 15 posts - 14,056 through 14,070 (of 59,101 total)

  • RE: OPEN TEXTFILE FROM T-SQL

    unas_sasing - Tuesday, October 17, 2017 8:50 PM

    unas_sasing - Tuesday, October 17, 2017 8:45 PM

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

    October 18, 2017 at 5:52 am

    #1964189

  • RE: TRUNCATE and INSERT INTO slower than TRUNCATE GO INSERT INTO

    mrpellepelle - Wednesday, October 18, 2017 3:13 AM

    Hi guys,

    any other solutions / explanations for this behaviour?
    I do not feel comfortable with...

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

    October 18, 2017 at 5:39 am

    #1964187

  • RE: Shared stored procedure with very complicated input

    mcraig 42832 - Tuesday, October 17, 2017 7:09 AM

    So, the basics of what I want to accomplish is simple...I have a 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)

    October 17, 2017 at 8:12 pm

    #1964136

  • RE: latest timestamp multiple databases

    The shortest thing would be to write a query that reads from the table and inserts the results into a common table using the undocumented and unsupported sp_MSForEachDB stored procedure,...

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

    October 17, 2017 at 8:06 pm

    #1964135

  • RE: Extract to CSV File

    wweraw25 - Tuesday, October 17, 2017 6:04 PM

    I have data something like below for one of the column.

    ADDRESS
    2248|("snake") ft NE, FTE 700

    When...

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

    October 17, 2017 at 7:14 pm

    #1964132

  • RE: Are the posted questions getting worse?

    Lynn Pettis - Tuesday, October 17, 2017 4:53 PM

    How do companies end up with people like this working with their databases?

    The interviewers...

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

    October 17, 2017 at 6:24 pm

    #1964128

  • RE: OPEN TEXTFILE FROM T-SQL

    What did you do?  Download from Equifax?

    I'm truly hoping that none of these files actually contain credit card numbers and other PII in plain text.

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

    October 17, 2017 at 5:27 pm

    #1964125

  • RE: Company moving premises (general question)

    JaybeeSQL - Tuesday, October 17, 2017 10:37 AM

    Hi all,

    I will soon be consulting to a company that is moving about 6 hours...

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

    October 17, 2017 at 5:13 pm

    #1964124

  • RE: Code for 'week to date' DATETIME() mine is displaying previous weeks

    chef423 - Tuesday, October 17, 2017 4:45 PM

    Lynn Pettis - Tuesday, October 17, 2017 4:36 PM

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

    October 17, 2017 at 5:06 pm

    #1964123

  • RE: Using Case with 2 different variables in one query

    montserrat.deza - Tuesday, October 17, 2017 3:46 PM

    Hello Experts,
    I am trying to use 2 cases in the same query and is not...

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

    October 17, 2017 at 4:19 pm

    #1964112

  • RE: Partition/Over Window Woes

    alex.sqldba - Tuesday, October 17, 2017 8:38 AM

    Well, I never knew you could put a case statement within a sum() ... AMAZING!!!

    Thanks...

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

    October 17, 2017 at 4:14 pm

    #1964110

  • RE: SQL CPU maxing out - need some guidance

    FritsD - Tuesday, October 17, 2017 3:16 AM

    Hi Jeff, thanls for the reply. No we didn't use EF and don't have MARS...

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

    October 17, 2017 at 6:01 am

    #1963994

  • RE: Using Date in Where Condition

    ChrisM@Work - Tuesday, October 17, 2017 5:50 AM

    Did you notice the timing for the fourth case, Jeff? It's just as...

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

    October 17, 2017 at 5:55 am

    #1963992

  • RE: Very challenging TSQL Query

    Naveen J V - Monday, October 16, 2017 8:58 AM

    Hi Experts,

    I have a table (test) with the following data :

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

    October 17, 2017 at 5:51 am

    #1963991

  • RE: Using Date in Where Condition

    ChrisM@Work - Tuesday, October 17, 2017 5:05 AM

    Jeff Moden - Saturday, October 7, 2017 9:10 PM

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

    October 17, 2017 at 5:44 am

    #1963989

    • Viewing 15 posts - 14,056 through 14,070 (of 59,101 total)