Forum Replies Created

Viewing 15 posts - 34,861 through 34,875 (of 59,102 total)

  • RE: Triggers

    HowardW (2/28/2011)

    sqlchanakya (2/28/2011)

    Am really looking for an answer or confirmation as how the disabling of a trigger is working. As I mentioned, is this the way that it will log...

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

    February 28, 2011 at 8:06 pm

    #1292687

  • RE: table not using index

    Colleen M. Morrow (2/28/2011)

    Updates to fields not covered by the index would not cause any extra overhead of maintaining the index, so no concerns there.

    "It Depends". 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)

    February 28, 2011 at 7:57 pm

    #1292686

  • RE: using oSQL utility

    I know this is of no help and I apologize for that but I have to know... A billion+ byte SQL Script? What on Earth does it do?

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

    February 28, 2011 at 7:31 pm

    #1292684

  • RE: is UNION ALL inherantly slow?

    BenWard (2/28/2011)

    Ah genius! thanks fellas 🙂

    having done some testing using insert instead of union is VASTLY quicker and requires less re-write of our existing programs so we'll probably end 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)

    February 28, 2011 at 7:22 pm

    #1292682

  • RE: High CPU usage due to bad execution plan occurs unexpectedly

    Gosh... if it's only running 100 times in 5 minutes, try adding OPTION(RECOMPILE) to the offending statement and you'll likely be done with the problem.

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

    February 28, 2011 at 7:14 pm

    #1292681

  • RE: documentation

    magasvs (2/28/2011)

    Something else important that you should request - installation media for all versions of SQL Server installed in company.

    And proof of licensing.

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

    February 28, 2011 at 6:49 pm

    #1292679

  • RE: Are the posted questions getting worse?

    Craig Farrell (2/28/2011)

    Personally preferring nice nylons myself, but that may have more to do with who I have in mind wearing them at the time....

    .... AAAAaaaaand I'm in trouble again....

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

    February 28, 2011 at 6:05 pm

    #1292674

  • RE: How to tune/speed up a procedure

    gregory.anderson (2/28/2011)

    Jeff Moden (2/21/2011)

    gregory.anderson (2/18/2011)

    Been searching on how to concatenate rows into a single field and I found a link to a recursive CTE for unknown number of rows 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)

    February 28, 2011 at 5:46 pm

    #1292672

  • RE: Are the posted questions getting worse?

    Craig Farrell (2/28/2011)

    Hey Jeff, your mailbox is full again. I didn't want to keep cluttering up the newbie's thread regarding unioning and the like, he's got enough confusion going...

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

    February 28, 2011 at 5:37 pm

    #1292667

  • RE: 'Pretty-up' the code

    The hierarchical examples of Recursive CTE's in BOL aren't that bad and they aren't actually full blown RBAR because they process full levels at a time instead of just one...

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

    February 28, 2011 at 5:11 pm

    #1292664

  • RE: Odd Questions

    Eric M Russell (2/28/2011)

    Jeff Moden (2/25/2011) . . .

    You're locked in a cell with a steel floor. At the center of the room is a pipe with massively thick...

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

    February 28, 2011 at 7:46 am

    #1292318

  • RE: SQL & the JOIN Operator

    SQLkiwi (2/27/2011)

    Jeff Moden (2/27/2011)

    Isn't this a bit like the article you wrote on designing databases? While I agree with all the things you've stated, entire books have been written...

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

    February 28, 2011 at 7:36 am

    #1292315

  • RE: Help needed to decode comma delimited string and insert into tables

    Thanks, Paul.

    I agree... in particular, I saw that 70% sort on the second use of the Tally Table and believe it would go away if we simply wrote the results...

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

    February 28, 2011 at 6:55 am

    #1292280

  • RE: How to solve this 2 query

    Craig Farrell (2/27/2011)

    Sorry for the delay, I was fiddling with the code you provided Jeff, trying to see what I'd not been paying attention to. I've known about 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)

    February 28, 2011 at 6:48 am

    #1292277

  • RE: Key Word Searches

    I was going to post that the result table and the related methods for this code article are nearly identical to what full-text-search (FTS) does but I see that folks...

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

    February 28, 2011 at 6:34 am

    #1292269

Viewing 15 posts - 34,861 through 34,875 (of 59,102 total)