Forum Replies Created

Viewing 15 posts - 39,136 through 39,150 (of 59,098 total)

  • RE: The Missing Certification

    Gift Peddie (3/31/2010)

    I came to SQL Server Central from Houston PASS, I stayed at SQL Server Central but I stopped attending PASS meetings five years ago. I may attend...

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

    March 31, 2010 at 9:12 pm

    #1143615

  • RE: The Missing Certification

    GSquared (3/31/2010)

    dma-669038 (3/31/2010)

    Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between table scan and index...

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

    March 31, 2010 at 9:00 pm

    #1143611

  • RE: The Missing Certification

    Lynn Pettis (3/31/2010)

    I thought about tis a bit more, and I still stand by earlier post. I could have wored it differently, however, by saying her comment was insulting...

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

    March 31, 2010 at 8:54 pm

    #1143610

  • RE: Why Be an MCP?

    Glenn Dorling (3/31/2010)

    Just thought I'd throw in my two bob's worth.

    I've only ever worked as a permanent employee and I've changed companies (not jobs/roles) very infrequently (3 companies in 25...

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

    March 31, 2010 at 8:46 pm

    #1143608

  • RE: Why Be an MCP?

    Steve Jones - Editor (3/31/2010)

    I'm not sure MS makes money on training. If they do, it's so little that it doesn't register on the annual report. A quick scan through...

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

    March 31, 2010 at 8:40 pm

    #1143606

  • RE: Why Be an MCP?

    Robert Davis (3/31/2010)

    So... Microsoft makes no money on training?

    Do you consider "makes no money" and "is not a profit center" to be the same thing?

    I don't know whether MSFT makes...

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

    March 31, 2010 at 5:14 pm

    #1143549

  • RE: The Missing Certification

    Lynn Pettis (3/31/2010)

    Gift Peddie (3/31/2010)

    Jeff Moden (3/29/2010)

    Gift Peddie (3/29/2010)

    All I want is please leave the doors open to all [font="Arial Black"]with the ability[/font].

    Exactly... 🙂

    Thanks Jeff I am off this thread...

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

    March 31, 2010 at 5:07 pm

    #1143548

  • RE: The Missing Certification

    Steve Jones - Editor (3/31/2010)

    Why do I feel this discussion has gotten way off track?

    Heh... it's still on track... but now it has a "third rail". 😀

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

    March 31, 2010 at 4:46 pm

    #1143546

  • RE: Trigger to send an email when ever a table is updated

    Thank you for the feedback, as well. It's actually a bit of a rare thing compared to the norm.

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

    March 31, 2010 at 4:43 pm

    #1143545

  • RE: Delete / Replace Blobs

    jtetler (3/31/2010)

    What I actually need is sample code on how to either delete the selected rows or preferably how to delete the images in those rows.

    Thanks,

    Jim

    Ummm... I'm thinking 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)

    March 31, 2010 at 2:09 pm

    #1143464

  • RE: Frequently fragmented indexes

    Marios Philippopoulos (3/30/2010)

    I'm on SQL 2008 SP1, Enterprise Ed.

    Since you have the Enterprise Edition, I'd consider partitioning the table and the indexes so they can be more easily managed. ...

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

    March 31, 2010 at 2:02 pm

    #1143458

  • RE: Best way to transpose multiple rows onto 1 row?

    derrysql (3/31/2010)

    Thanks to everyone who responded to my question.

    With the various replies I was able to obtain what I required.

    rg

    Very cool... just one thing left for you to do... 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)

    March 31, 2010 at 1:58 pm

    #1143456

  • RE: Trigger to send an email when ever a table is updated

    malachyrafferty (3/31/2010)

    Hi jeff

    could you tell why this will wait until all updates are notified? i know it does i just dont understand why :w00t:

    what is the SELECT @msg = ISNULL...

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

    March 31, 2010 at 1:54 pm

    #1143450

  • RE: Are the posted questions getting worse?

    lmu92 (3/31/2010)

    How does a search engine express it's/his/her feelings anyway?

    heh... search me... 😛

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

    March 31, 2010 at 1:41 pm

    #1143444

  • RE: The Missing Certification

    Grant Fritchey (3/31/2010)

    dma-669038 (3/31/2010)

    Well said. And 100 percent in agreement. Want to share one expereince - One guy i talked to did not know the difference between table scan 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)

    March 31, 2010 at 1:31 pm

    #1143430

Viewing 15 posts - 39,136 through 39,150 (of 59,098 total)