Forum Replies Created

Viewing 15 posts - 38,041 through 38,055 (of 59,098 total)

  • RE: Selecting the earliest month wrapping January to December

    bteraberry (6/8/2010)

    Jeff Moden (6/8/2010)

    Unless I'm missing something, this problem is impossible to solve because there's simply nothing to guarantee the order of the data. There has to be 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)

    June 9, 2010 at 11:14 pm

    #1178437

  • RE: get count from count query

    As a sidebar and extension of the problem... lookup WITH ROLLUP and WITH CUBE as associated with GROUP BY. Powerful tools there. 😉

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

    June 9, 2010 at 11:06 pm

    #1178434

  • RE: Alter command

    pujain (6/9/2010)

    Hi All,

    i need to alter multiple column in from null to not null in production server.

    table have millions of records, and taking each alter is taking hours to run....

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

    June 9, 2010 at 10:57 pm

    #1178431

  • RE: Alter command

    CirquedeSQLeil (6/9/2010)

    Two options

    Create a cursor that does essentially the same thing I just showed you.

    or

    Run that script, review the commands, and then set it up in a job to execute...

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

    June 9, 2010 at 10:43 pm

    #1178424

  • RE: exclude one column

    Heh... drat... day late and a dollar short. I just saw what Grant already posted.

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

    June 9, 2010 at 10:40 pm

    #1178422

  • RE: exclude one column

    tripri (6/9/2010)

    hi,

    i got a table with almost 20 columns. Now the problem is

    if i do

    Select * from table

    i will get all the wenty columns

    what if i want only 19...

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

    June 9, 2010 at 10:39 pm

    #1178421

  • RE: Is the MVP Worth It?

    To answer the question of "Is the MVP Worth It?", the answer IMHO is absolutely "No". As someone previously noted on this thread, most good MVPs (and even some...

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

    June 9, 2010 at 10:31 pm

    #1178417

  • RE: Is the MVP Worth It?

    GilaMonster (6/9/2010)

    Yes.

    Personally I lurk on forums, write blog posts and articles and present because I enjoy it, not because I'm paying dues or trying for an award. I'd be doing...

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

    June 9, 2010 at 9:21 pm

    #1178403

  • RE: Is the MVP Worth It?

    blandry (6/9/2010)

    In over 30 years in this business, I have rarely seen anyone with an MVP award who actually measures up to being an "MVP" - and worse, in some...

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

    June 9, 2010 at 9:19 pm

    #1178402

  • RE: Is the MVP Worth It?

    James Stover (6/9/2010)

    If I were to choose between putting in the hard yards for a MVP vs. MBA, I would absolutely go for the MBA. I also dare say there...

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

    June 9, 2010 at 8:52 pm

    #1178398

  • RE: Splitting One Row Data into Two Rows

    Understood. You might want to look into the use of [0-9] and [^0-9] just to simplify the code a bit.

    Nicely done on the two row "embedded Tally Table" for...

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

    June 9, 2010 at 8:26 pm

    #1178393

  • RE: High Transactions per second

    TheSQLGuru (6/9/2010)

    BTW, are you at TechEd this week?

    No... I've got one of those major project thingies going on at work.

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

    June 9, 2010 at 8:21 pm

    #1178392

  • RE: SQL Server Ranking Functions

    I'm a little late on the feedback after the formatting fix and I apologize for that. VERY nicely done, Wayne. This will help a lot of folks just...

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

    June 9, 2010 at 8:12 pm

    #1178390

  • RE: Changing dates to Integers

    Patrick Seegers (6/9/2010)

    [font="Courier New"]Are there any opposing views on this usage?

    Thank you

    [/font]

    Sure... read the rest of the posts on this thread.

    Hmmmm.... "unknown date".... sounds like...

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

    June 9, 2010 at 5:40 pm

    #1178375

  • RE: Why this Convert has a small quirk?

    Hi Roy,

    Heh... I had to laugh a bit because I'm right there with you. Seems the phrase "legacy code" usually means "problem code"... even if it was us that...

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

    June 9, 2010 at 6:49 am

    #1177942

Viewing 15 posts - 38,041 through 38,055 (of 59,098 total)