Forum Replies Created

Viewing 15 posts - 38,986 through 39,000 (of 59,098 total)

  • RE: delete repeating rows

    As a bit of a side bar, if you key off the ROW_NUMBER for the DELETE, you can eliminate one full execution of the CTE. Like 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 8, 2010 at 7:52 pm

    #1148749

  • RE: delete repeating rows

    COldCoffee (4/8/2010)

    Jeff Moden (4/8/2010)

    Sorry... I didn't scroll down to see COldCoffee's solution which is a coded example of what Lutz was talking about.

    No issues Jeff... i am infact feeling great...

    --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 8, 2010 at 3:44 pm

    #1148696

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (4/8/2010)

    Gianluca Sartori (4/8/2010)

    WayneS (4/7/2010)

    As a parent, you always need to be ready to follow through on any threat that you make. And the sooner you do it, the sooner...

    --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 8, 2010 at 2:41 pm

    #1148657

  • RE: Date Manipulation with DATEADD/DATEDIFF

    SQLJeff (4/8/2010)

    And what about the old CONVERT(VARCHAR(12),GETDATE(),101), will this work in some cases?

    Most likely... but the problem with that is as I previously stated... it uses twice as much CPU...

    --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 8, 2010 at 7:11 am

    #1148243

  • RE: FizzBuzz

    Gianluca Sartori (4/8/2010)

    Looking at the execution plans, it should not be faster.

    Heh... I've run into that many, many times. Perhaps an article titled "The execution plan lies". 😛

    --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 8, 2010 at 7:07 am

    #1148238

  • RE: delete repeating rows

    Sorry... I didn't scroll down to see COldCoffee's solution which is a coded example of what Lutz was talking about.

    --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 8, 2010 at 6:51 am

    #1148216

  • RE: delete repeating rows

    Kajal123 (4/7/2010)

    Hi all,

    I am having hard time forming this query to dedulicate - duplicate rows in a table:

    select 1_KEY,2_KEY

    from MY_TABLE

    group by 1_KEY,2_KEY

    having count(*) >1

    now this query gives...

    --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 8, 2010 at 6:48 am

    #1148212

  • RE: Which is better and Why.?

    Just to summarize and answer the question being asked right up front...

    If you have people that can write good code in either, both Oracle and SQL Server are very, very...

    --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 8, 2010 at 6:29 am

    #1148184

  • RE: Do table variables log records in transaction log?

    And, no... table variables are not logged. That's part of the reason why they aren't/can't be rolled back.

    --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 8, 2010 at 5:44 am

    #1148152

  • RE: Bulk Insert more than one CSV file

    Your code points to drive "D". That drive must be on the server and it must not be a "mapped drive". If you want the server to read...

    --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 8, 2010 at 5:42 am

    #1148149

  • RE: Have some question

    miss.delinda (4/8/2010)

    tq to all. i'll learn to using Books Online

    KO 10Q. Thanks for the feedback. Yeah... these questions are easily answered by looking up key words like "Temp...

    --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 8, 2010 at 5:33 am

    #1148147

  • RE: Who "Owns" the Database?

    The "users" own the data but you must assume ownership enough to protect the data even from them. Heh... Perhaps a small poem I heard a long time ago...

    --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 7, 2010 at 8:09 pm

    #1147968

  • RE: Have some question

    lmu92 (4/7/2010)

    GregoryF (4/7/2010)

    I think you have gone way beyond the scope of someone who asked what the difference between delete and truncate is 🙂 Don't confuse them while they...

    --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 7, 2010 at 7:49 pm

    #1147958

  • RE: Have some question

    miss.delinda (4/7/2010)

    I've question as follow,

    1. How many types of temporary tables exist in SQL Server and how is each type symbolized?

    2. What is the lifetime and visibility of each type?

    3....

    --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 7, 2010 at 7:43 pm

    #1147957

  • RE: How to fing first letter is a number or letter in a column

    Jason Selburg (4/7/2010)

    test for numeric:

    ISNUMERIC(LEFT(yourFieldName,1)) = 1

    Heh... you sure about that ol' friend?

    SELECT ISNUMERIC(LEFT('$Howdy',1)),

    ISNUMERIC(LEFT(',Howdy',1)),

    ...

    --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 7, 2010 at 7:25 pm

    #1147955

Viewing 15 posts - 38,986 through 39,000 (of 59,098 total)