Forum Replies Created

Viewing 15 posts - 21,151 through 21,165 (of 59,072 total)

  • RE: System DMV's Cause Blocking

    No. But now I'm curious about why you ask. Have you seen such a thing or are you "just" concerned?

    --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 25, 2015 at 5:37 pm

    #1786442

  • RE: What would Fill Factor Do?

    Wayne West (3/25/2015)

    PHYData DBA (3/24/2015)

    ... Also they seem to see this as a "Magic Bullet" to resolve not a performance issue, but and issue with increase in Table space.

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

    March 25, 2015 at 5:35 pm

    #1786440

  • RE: BUILTIN\Administrators login doesn't appear to be working.

    nitefalll (3/25/2015)

    First let me say I'm a huge fan of Lowell.

    We attempted to add a new administrator to a 2012 box like we've done before with 2008R2 and previous....

    --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 25, 2015 at 5:33 pm

    #1786439

  • RE: Want to return character(s) after a dash (-)

    ScottPletcher (3/25/2015)

    You can specify a longer length on the SUBSTRING and it won't hurt anything, so you skip calculating the length; for example:

    SELECT SUBSTRING(string_value, CHARINDEX('-', string_value) + 1, 100)

    +100

    --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 25, 2015 at 4:28 pm

    #1786433

  • RE: Split function that allows multiple character delimitter

    Marcus Farrugia (3/25/2015)

    Hi I have a table with a varchar column that is delimited by char(227)+char(228)

    ie,

    OrNo=7807ãäSeqNo=1ãäPStopType=PãäPCity=TillsonburgãäPSt=ONãäPZIP=N4G4J1ãäPAdr1=10 ROUSE STREETãäPAdr2=ãäPLat=42.8625ãäPLon=-80.7267ãäDStopType=DãäDCity=GaffneyãäDSt=SCãäDZIP=29341ãäDAdr1=121 PAN AMERICAN DRIVE

    would anyone be able to point me to 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)

    March 25, 2015 at 3:55 pm

    #1786429

  • RE: Query running very slow

    Grant Fritchey (3/25/2015)

    I'd really focus on the execution plan. I suspect the MAX itself isn't causing issues but rather the GROUP BY.

    One way around it would be to try getting...

    --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 25, 2015 at 1:28 pm

    #1786411

  • RE: The Worst Comments

    LightVader (3/25/2015)

    ChrisM@Work (3/25/2015)

    Jeff Moden (3/24/2015)

    Eirikur Eiriksson (3/24/2015)

    Wayne West (3/23/2015)

    Jeff Moden (3/22/2015)

    Steve Jones - SSC Editor (3/16/2015)

    Eirikur Eiriksson (3/13/2015)

    Digressing slightly, how would the threadizens describe the optimal code comments? Obviously 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)

    March 25, 2015 at 9:10 am

    #1786340

  • RE: Doubt about logic in T-SQL

    marco alves (3/24/2015)

    Cadavre,

    Thank you for your help.

    What I expect as a result is to update the "Product" table, on the column "qtt_terminal".

    Here is a picture with example output data based...

    --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 24, 2015 at 11:09 pm

    #1786178

  • RE: Vendor Changed the Flat File Format

    Vertigo44 (3/24/2015)

    5 was just a made up number. I actually need all columns up until the last two in the after file. Thanks for your help on this!

    If that's 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)

    March 24, 2015 at 8:44 pm

    #1786176

  • RE: Vendor Changed the Flat File Format

    Vertigo44 (3/24/2015)

    Hi Jeff,

    See attached. I only included the file headers in the file as I think that's all your really need to see what is taking place. If the FF...

    --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 24, 2015 at 8:29 pm

    #1786174

  • RE: bulk insert

    That's good. Thanks for that. But, we first have to get the data into a table. The problem at hand is to import the data, correct? ...

    --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 24, 2015 at 8:04 pm

    #1786171

  • RE: convert from access to sql server please help

    pietlinden (3/24/2015)

    Are you going to show the results of this in Reporting Services? (Yes, I know Jeff hates SSRS...)

    If so, you don't need to do the Pivot in SQL Server...

    --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 24, 2015 at 7:09 pm

    #1786165

  • RE: Call Stored Procedure from a Function

    Nuhamovici (3/24/2015)

    Yes, it looks like this is so evil, it shouldn't even be attempted!

    Uh huh. And AC electricity wouldn't be the norm if people listened to the naysayers 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)

    March 24, 2015 at 4:39 pm

    #1786150

  • RE: The Worst Comments

    Eirikur Eiriksson (3/24/2015)

    Wayne West (3/23/2015)

    Jeff Moden (3/22/2015)

    Steve Jones - SSC Editor (3/16/2015)

    Eirikur Eiriksson (3/13/2015)

    Digressing slightly, how would the threadizens describe the optimal code comments? Obviously the opposite of that 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)

    March 24, 2015 at 4:22 pm

    #1786145

  • RE: Vendor Changed the Flat File Format

    Vertigo44 (3/24/2015)

    Yes, I just stepped into this environment not too long ago but apparently this has been happening with the vendor for over 2 years now. Its been brought up...

    --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 24, 2015 at 1:05 pm

    #1786081

Viewing 15 posts - 21,151 through 21,165 (of 59,072 total)