Forum Replies Created

Viewing 15 posts - 39,106 through 39,120 (of 59,072 total)

  • RE: Overactive use of Temp Tables?

    Usually, "It depends". This time, "It doesn't matter". 😉

    Even without the Temp Table and going direct, you'd likely get a recompile everytime anyway because of the amount of data...

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

    #1143636

  • RE: DBCC Timewarp

    I'm a bit disappointed... no mention of the hampster poo enhancement. 😛

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

    #1143632

  • RE: Delete / Replace Blobs

    jtetler (3/31/2010)

    Lowell,

    Thanks for the code. I probably won't get to try it 'til next week or so - I'll be travelling a bit, but I'll let you know how...

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

    #1143622

  • RE: The Missing Certification

    Jeff Moden (3/31/2010)

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

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

    #1143619

  • 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

Viewing 15 posts - 39,106 through 39,120 (of 59,072 total)