Forum Replies Created

Viewing 15 posts - 50,971 through 50,985 (of 59,102 total)

  • RE: The Exceptional DBA: Soft Skills

    You've summarized the soft skills very nicely, Tony. And, I absolutely agree, David Poole's well thought out statement of "if people will voluntarily use you as the first point...

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

    April 26, 2008 at 10:49 am

    #807508

  • RE: DTS - loading mixed data types from text file.

    intvfan (4/26/2008)

    I still would love to have the log not grow!!! I am loading millions of rows in several tables.

    I would love to BULK load. Do you bulk...

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

    April 26, 2008 at 9:12 am

    #807505

  • RE: Date String

    You don't need to worry about DateFirst with the following...

    [font="Courier New"] SELECT LEFT(DATENAME(dw,GETDATE()),3)

    + ', ' + CONVERT(VARCHAR,GETDATE(),106)[/font]

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

    April 25, 2008 at 8:41 pm

    #807475

  • RE: Cursor ends when I don't want it too

    Have you got a server called "FindUsers"??? That's where the error is on my machine...

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

    April 25, 2008 at 8:36 pm

    #807474

  • RE: Can't see owned tables

    Sounds like someone changed a role or reassigned a role. Maybe even changed to Windows Authentication without doing the necessary work to keep privs.

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

    April 25, 2008 at 8:25 pm

    #807471

  • RE: DTS - loading mixed data types from text file.

    I import all columns as VARCHAR and evaluate from there. You should only import to a staging table... there you can make such decisions before transferring to the final...

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

    April 25, 2008 at 8:22 pm

    #807470

  • RE: Extracting Rows from Delimited Strings

    Matt Miller (4/25/2008)

    Jeff - that last code nulls out the 0's in the 3rd column - is it supposed to?

    Nah... I screwed up.

    The real key to this whole thing 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)

    April 25, 2008 at 8:17 pm

    #807468

  • RE: CTE's are useless

    Seggerman (4/25/2008)

    There are times (not too often) where speed at any cost is unwise

    I may be a newbie at SQL Server but in computer programming for over 3 decades

    my current...

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

    April 25, 2008 at 8:00 pm

    #807466

  • RE: User Defined Function - Passing and Processing a Table

    rbarryyoung (4/16/2008)

    I am confused. Why isn't robert's answer sufficient?

    I agree... why is everyone still looking for an aggegate function and passing columns of data when Robert's very simple formula...

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

    April 25, 2008 at 7:42 pm

    #807464

  • RE: BCP Trigger Hangs up Insert Statement

    Another problem other than the ones already stated is that even if all of this worked correctly, BCP destroys existing files and overwrites them.

    I may have a work-around for this,...

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

    April 25, 2008 at 7:28 pm

    #807463

  • RE: DELETE DUPLICATE RECORDS

    Ariel Dimapilis (4/23/2008)

    Hi All

    Anyone can help me how to delete a duplication records retain one value in one table

    Can anyone give a script for deleting duplicates records.

    Please help me, I'm...

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

    April 25, 2008 at 5:29 pm

    #807446

  • RE: Working with strings

    What is the primary key of the matrix? Also, not that we'll necessarily need it, but can Dynamic SQL be used?

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

    April 25, 2008 at 3:31 pm

    #807427

  • RE: querying a string

    GSquared (4/25/2008)

    That's going to work better than spaces around the "like" statement. Of course, if you want it to include "pros" (plural), or "professional"/"professionals", you can add to 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)

    April 25, 2008 at 7:58 am

    #807185

  • RE: querying a string

    MarkusB (4/25/2008)

    In order to work correctly, you must surround the source and target with the delimiters in the column... in this case, spaces.

    [font="Courier New"]SELECT myvarcharCol from mytable

    WHERE ' '+myvarcharCol+' '...

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

    April 25, 2008 at 7:56 am

    #807184

  • RE: Get rid of Dynamic SQL

    I use this one often...

    [font="Courier New"]...

    ...

    WHERE (@A = AColumn OR @A IS NULL)

    AND (@B = BColumn OR @b-2 IS NULL)

    AND...

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

    April 25, 2008 at 7:47 am

    #807180

Viewing 15 posts - 50,971 through 50,985 (of 59,102 total)