Forum Replies Created

Viewing 15 posts - 25,816 through 25,830 (of 59,102 total)

  • RE: Is possible create numbered sequences

    Gosh, I'm sorry. I see that this post is 6 weeks old and no one picked up on it. The following will do it for you. Change...

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

    September 27, 2013 at 8:06 pm

    #1654240

  • RE: What is your favorite "I didn't know that" moment in T-SQL?

    Apologies for the very late reply, Tom. Thanks for the detailed explanation about xp_CmdShell in SQl Server 2000. I knew a good amount of that but it was...

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

    September 27, 2013 at 6:18 pm

    #1654235

  • RE: Shift week to Wed - Tues

    Michael Valentine Jones (9/27/2013)

    Jeff Moden (9/26/2013)

    Michael Valentine Jones (9/26/2013)

    Jeff Moden (9/26/2013)

    Michael Valentine Jones (9/25/2013)

    That's not really the best way to go because it depends on the setting of a run-time...

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

    September 27, 2013 at 3:59 pm

    #1654219

  • RE: Shift week to Wed - Tues

    ScottPletcher (9/27/2013)

    Why mess with the DATEFIRST setting when it's not necessary? There are methods which can do the calculation simply without needing a specific datefirst setting, so why hassle...

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

    September 27, 2013 at 3:58 pm

    #1654218

  • RE: Are the posted questions getting worse?

    Sean Lange (9/27/2013)

    SQLRNNR (9/27/2013)

    Sean Lange (9/27/2013)

    Luis Cazares (9/27/2013)

    Sean Lange (9/27/2013)

    Luis Cazares (9/27/2013)

    Today, I'm really pissed off with the database and network administrators. Because of the lack of good planning 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)

    September 27, 2013 at 3:14 pm

    #1654213

  • RE: Are the posted questions getting worse?

    Luis Cazares (9/27/2013)

    Sean Lange (9/27/2013)

    Luis Cazares (9/27/2013)

    Today, I'm really pissed off with the database and network administrators. Because of the lack of good planning and best practices, instead of restrictions...

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

    September 27, 2013 at 3:11 pm

    #1654212

  • RE: Best way to store images

    Snigdha Vartak (8/20/2013)

    Storing files on File Server is better option if file size is huge.

    When you make such a statement, it would be good if you provided a reason why....

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

    September 26, 2013 at 9:10 pm

    #1653831

  • RE: Best way to store images

    Ed Wagner (3/12/2013)

    I've never used the filestream so I won't comment on it, but I have stored images (and lots of other file types, such as AutoCad) in Oracle 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)

    September 26, 2013 at 9:06 pm

    #1653830

  • RE: Best Index Rebuild/Reorganize and Update Statistics Strategy

    GilaMonster (7/21/2013)

    Jeff Moden (7/21/2013)

    You can simply change back to the FULL recovery mode if in Bulk Logged ....

    You can, but a log backup right before or after the switch...

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

    September 26, 2013 at 8:28 pm

    #1653829

  • RE: Automate Your Backup and Restore Tasks

    Jonathan Mallia (9/24/2013)

    It's far better to set the database to SINGLE user mode with ROLLBACK IMMEDIATE, immediately return it to MULTI user mode ....

    The 'with ROLLBACK IMMEDIATE' will automaticcaly kill...

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

    September 26, 2013 at 8:17 pm

    #1653826

  • RE: Automate Your Backup and Restore Tasks

    Jeffrey Williams 3188 (9/23/2013)

    Jeff Moden (9/23/2013)

    2Tall (9/20/2013)

    Be careful with killing SPIDs. I forget the URL for the CONNECT item on this but you could easily end up with 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)

    September 26, 2013 at 8:04 pm

    #1653824

  • RE: Are the posted questions getting worse?

    SQLRNNR (9/26/2013)

    The water cooler has done it again. Thanks Jeff et al for the laughs.:-D:-D:-D

    Heh... after the last couple of weeks at work, pork chop acceleration technology just seemed...

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

    September 26, 2013 at 7:34 pm

    #1653820

  • RE: Shift week to Wed - Tues

    Michael Valentine Jones (9/26/2013)

    Jeff Moden (9/26/2013)

    Michael Valentine Jones (9/25/2013)

    That's not really the best way to go because it depends on the setting of a run-time session parameter, DATEFIRST.

    Although I certainly...

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

    September 26, 2013 at 5:38 pm

    #1653806

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (9/25/2013)

    wolfkillj (9/25/2013)

    What's the terminal velocity of a potato?

    European or African?

    Unladen or laden with butter, sour cream, bacon bits, etc.?

    Dang... I thought you were talking about 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)

    September 26, 2013 at 5:32 pm

    #1653804

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (9/25/2013)

    I always figured they were fired by a disc-gun-like device ...

    Ooooooooo.... you've just given me an idea. Reminds me of a child-hood toy I had. I...

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

    September 26, 2013 at 5:30 pm

    #1653802

Viewing 15 posts - 25,816 through 25,830 (of 59,102 total)