Forum Replies Created

Viewing 15 posts - 38,146 through 38,160 (of 59,072 total)

  • RE: Select Average By DATEPART Weekday

    Hi Mike,

    Heh... yeah, I realize it's a holiday weekend but it's also been way more than 24 hours since you posted. Remember what I suggested on a previous post...

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

    May 29, 2010 at 10:15 pm

    #1174287

  • RE: Auto Increment Alphabet

    Even though I still don't like this kind of "numbering", let's try things in a slightly different manner. If we remove all the vowels from the alphabet, it's 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)

    May 29, 2010 at 12:26 am

    #1174212

  • RE: Auto Increment Alphabet

    @ankit (or anyone else who thinks this type of "numbering" is a good idea),

    Let me tell you why BASE 26 "numbering" like this is SO bad that it'll likely get...

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

    May 28, 2010 at 11:28 pm

    #1174211

  • RE: Auto Increment Alphabet

    Alright... here you go. First, we'll demo a way to accomplish the task and then I'll show in the post following this one why this type of numbering should...

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

    May 28, 2010 at 10:54 pm

    #1174210

  • RE: Auto Increment Alphabet

    This isn't right. First, using base 26 numbering isn't ever the right thing to do IMHO but if you're going to do it, let's do it so it's not...

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

    May 28, 2010 at 10:05 pm

    #1174209

  • RE: Auto Increment Alphabet

    ColdCoffee (5/28/2010)

    @Wayne Shef, mate, am not as experienced or as agile or as smart as u are in coding; please dont mistake me for editing your code, just that 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)

    May 28, 2010 at 3:29 pm

    #1174162

  • RE: String Help - LTRIM ?

    Atif Sheikh (5/28/2010)

    How about writing a function as;

    [/code]

    Although it's tempting to use such a thing, be very aware that the use of such scalar functions will slow your code down......

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

    May 28, 2010 at 1:45 pm

    #1174112

  • RE: Simple scalar function slows down query

    Nice job, Lowell.

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

    May 28, 2010 at 1:44 pm

    #1174110

  • RE: Import and Export

    If you have a SAN, see if it has the ability to do a "SAN Clone" or "SAN Snapshot". We did that at one company I worked at. ...

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

    May 28, 2010 at 1:33 pm

    #1174107

  • RE: Delete Vs Truncate

    Perry Whittle (5/28/2010)

    Jeff Moden (5/27/2010)

    Just don't throw the book at me. 😛

    No give him a taste of his own medicine and throw a few pork chops instead 😀 :laugh:

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

    May 28, 2010 at 12:35 pm

    #1174096

  • RE: Delete Vs Truncate

    Sahasam (5/28/2010)

    Jeff,

    I went through many of the questions you answered, i really like your explanations.

    Thanks for simplifying the words in layman terms.

    Sahasam..

    Thanks, Sahasam.

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

    May 28, 2010 at 12:34 pm

    #1174095

  • RE: Delete Vs Truncate

    nitu.guptaji (5/28/2010)

    mean at the time of deletion log file is maintened we can recover data but in the case of truncation we can not recover because it doesn't maintain 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)

    May 28, 2010 at 12:34 pm

    #1174094

  • RE: Would You Do Your Hobby for a Living

    It's a funny thing. I do SQL for a hobby, love it, and do it for a job. I also have several other hobbies but, for some reason,...

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

    May 27, 2010 at 11:29 pm

    #1173726

  • RE: Delete Vs Truncate

    Ratheesh.K.Nair (5/27/2010)

    Thanks Jeff.That was really nice example and i liked the way u explained simple but really powerful so that noone will forget

    Thanks for the nice compliment, Ratheesh. Heh......

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

    May 27, 2010 at 11:09 pm

    #1173723

  • RE: Jst a query......

    Maddy...! (5/27/2010)

    Mr. Moden

    I gave that statement bcoz Dave gave me some blog link to verify so i asked him and told him if you can...

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

    May 27, 2010 at 11:06 pm

    #1173721

Viewing 15 posts - 38,146 through 38,160 (of 59,072 total)