• below86 (1/3/2014)


    Jeff Moden (1/3/2014)


    ..."Tips'n'Tricks" ....

    Is there a place on this site where these type tips and tricks can/are posted? Under 'Scripts'? Or is there a place under the 'Forums'? Honestly I haven't looked yet, I don't know why I haven't thought of it. :crazy: I know we (developers) here try to pass around and tips or tricks we learn to the entire group. But it is hard for everyone to keep track of these, we don't have our own WIKI site, there was talk at one time but as with a lot of things that would benefit us, it gets pushed back to meet the users demands.

    There's the "Stairways" Series of articles that go in depth on certain subjects but I suspect you want things a bit shorter and more direct than those (left side of the screen here on SQL Server Central). You would think that the "Scripts" section would be the place to look but I advise caution there. Those scripts aren't reviewed by a technical team and, just like anywhere else on the internet, some are excellent, some will kill your server, and the rest fall in varying degrees betwixt the two.

    My recommendation would be to check on the articles of some of the "heavy hitters" on this forum and some of the many heavy hitters that post replies on the forums and add them to your "briefcase" which is located just above this window.

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