Forum Replies Created

Viewing 15 posts - 39,151 through 39,165 (of 59,098 total)

  • RE: The Missing Certification

    dma-669038 (3/31/2010)

    CirquedeSQLeil (3/31/2010)

    Jeff Moden (3/31/2010)

    Maybe I've been spoiled by the likes of folks like the denizens of SSC but it sure does seem to me that the SQL Server IQ...

    --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:26 pm

    #1143424

  • RE: The Missing Certification

    GSquared (3/30/2010)

    Jeff Moden (3/30/2010)

    No... you're quite correct about SSIS and SSRS. The difference between myself and many managers is before I'd conduct interviews for a position that required either...

    --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:04 pm

    #1143399

  • RE: The Missing Certification

    CirquedeSQLeil (3/30/2010)

    Lynn Pettis (3/30/2010)

    Jason, I read your blog post and I'm not sure what else I could add to your well written summary of the discussion we have been having...

    --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 12:53 pm

    #1143378

  • RE: The Missing Certification

    Lynn Pettis (3/30/2010)

    WayneS (3/30/2010)

    Jeff Moden (3/30/2010)

    If you ever sat through one of my interviews, you would change your mind about that. I only need an hour or so 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 12:49 pm

    #1143372

  • RE: Why Be an MCP?

    Lynn Pettis (3/30/2010)

    Jeff Moden (3/30/2010)

    matt stockham (3/30/2010)

    I guess you aren't a supporter of further education then, being as most graduates paid to get those letters after their name.

    I support higher...

    --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 12:21 pm

    #1143341

  • RE: Why Be an MCP?

    GilaMonster (3/30/2010)

    Jeff Moden (3/30/2010)

    AspiringGeek-40457 (3/30/2010)

    I can guarantee that training is *not* a profit center for Microsoft.

    Unless you work for Microsoft or have a Microsoft URL stating that, I'm pretty sure...

    --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 12:15 pm

    #1143334

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

    malachyrafferty (3/30/2010)

    sure i can 😀

    create trigger TestStock on dbo.mal_test After insert as

    declare @StockCode varchar(10)

    declare @Description varchar(10)

    set @StockCode =(select StockCode from Inserted)

    set @Description =(select Description from Inserted)

    begin

    declare @msg varchar(500)

    set...

    --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 30, 2010 at 3:38 pm

    #1142760

  • RE: Why Be an MCP?

    matt stockham (3/30/2010)

    I guess you aren't a supporter of further education then, being as most graduates paid to get those letters after their name.

    I support higher education... so long as...

    --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 30, 2010 at 1:50 pm

    #1142652

  • RE: Delete / Replace Blobs

    jtetler (3/29/2010)

    I would greatly appreciate any ideas on how to solve this problem. The company that wrote the software wants $$$$7500 to write a one time script to delete rows....

    --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 30, 2010 at 1:40 pm

    #1142638

  • RE: Delete / Replace Blobs

    jtetler (3/29/2010)

    I can determine the ImageID for 6 months ago from an old backup so that would be my starting point.

    Thanks,

    Jim

    So find out what that ID is and delete everything...

    --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 30, 2010 at 1:38 pm

    #1142636

  • RE: Datediff doubt

    I know, Dugi, and I appreciate your efforts. The problem is that not just the OP will read such a thing. Someone with similar but slightly different requirements...

    --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 30, 2010 at 1:26 pm

    #1142626

  • RE: Why Be an MCP?

    Question Guy (3/30/2010)

    I'd have to say battlefield experience takes a huge it when a person does not have certifications. Whenver I've been interviewed, people were typically excited that I had...

    --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 30, 2010 at 1:20 pm

    #1142618

  • RE: Why Be an MCP?

    AspiringGeek-40457 (3/30/2010)

    I can guarantee that training is *not* a profit center for Microsoft.

    Unless you work for Microsoft or have a Microsoft URL stating that, I'm pretty sure you can make...

    --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 30, 2010 at 1:18 pm

    #1142615

  • RE: any tips on anonymising data

    aaron.reese (3/30/2010)

    Hi guys,

    I am being asked to restore a live database to a training environment. The database contains patient confidential records and I would like to keep all of...

    --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 30, 2010 at 1:15 pm

    #1142612

  • RE: Frequently fragmented indexes

    Marios Philippopoulos (3/30/2010)

    I have noticed that a number of nonclustered indexes in my database are getting frequently (almost daily) fragmented (fragmentation > 10%).

    Because of the size of the underlying...

    --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 30, 2010 at 1:13 pm

    #1142608

Viewing 15 posts - 39,151 through 39,165 (of 59,098 total)