Forum Replies Created

Viewing 15 posts - 22,696 through 22,710 (of 59,102 total)

  • RE: Table creation policies. Is this silly or is it just me?

    Luis Cazares (8/25/2014)

    The sad reality is that "very controlled, monitored and process oriented system" is just a nice wish as there are many things that just get into production 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)

    October 1, 2014 at 8:41 am

    #1749415

  • RE: Expired SQL 2012 license. Moving on to 2014

    Dante Garcia (8/26/2014)

    Hello, I'm having an issue with an expired license.

    I have a development database in SQL 2012 in which I had been working till the license expired today. 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)

    October 1, 2014 at 7:57 am

    #1749400

  • RE: Problem w/temporary tables in Stored Procedure accessed by SSRS

    psullivan (9/14/2004)

    remember #temp is going away in favor of the the above..

    Heh... I know it's an old post but 10 years have gone by and that hasn't come close to...

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

    September 30, 2014 at 5:20 pm

    #1749285

  • RE: Why do they not listen?

    Eric M Russell (9/30/2014)

    GilaMonster (9/30/2014)

    Eric M Russell (9/29/2014)

    Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.

    "I'm so sorry, I know...

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

    September 30, 2014 at 8:12 am

    #1749164

  • RE: Why do they not listen?

    GilaMonster (9/30/2014)

    Eric M Russell (9/29/2014)

    Upgrading to the next release of SQL Server offers an excellent pretext for removing unneeded permissions from app developers.

    "I'm so sorry, I know it a pain...

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

    September 30, 2014 at 7:41 am

    #1749145

  • RE: Remove non alpha chars from a column

    CELKO (9/30/2014)

    I use nested REPLACE() functions. Some day we might have the ANSI/ISO Standard TRANSLATE()

    Hi Joe,

    I agree that using nested replace functions are the berries for performance especially when replacing...

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

    September 30, 2014 at 7:36 am

    #1749137

  • RE: how to install N no of Sql server at a time

    santoshkal (9/23/2014)

    HI,

    I would like to know how to install N no of SQL server at a single go

    is there any process by ISO file or any other method

    Thanks

    Considering...

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

    September 29, 2014 at 1:36 pm

    #1748925

  • RE: Why do they not listen?

    Alvin Ramard (9/29/2014)

    Luis Cazares (9/29/2014)

    Revoke create and alter permissions and create policies to apply changes to the database. People will start to do things right when they're enforced.

    That only works...

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

    September 29, 2014 at 1:31 pm

    #1748923

  • RE: Why do they not listen?

    Eric M Russell (9/29/2014)

    Koen Verbeeck (9/29/2014)

    Hire an overpriced consultant. Chances are they'll listen to him/her...

    Quit, and then be that overpriced consultant.

    +1000!

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

    September 29, 2014 at 1:30 pm

    #1748922

  • RE: Why do they not listen?

    Koen Verbeeck (9/29/2014)

    Hire an overpriced consultant. Chances are they'll listen to him/her...

    BWAAAA-HAAA!!! BECOME and overpriced consultant! 😉

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

    September 29, 2014 at 1:28 pm

    #1748921

  • RE: Random values

    TomThomson (9/29/2014)

    edwardwill (9/29/2014)

    I don't use the Redgate tool so I can't comment on that - I tend to write my code directly into a Management Studio window (or, if 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)

    September 29, 2014 at 11:30 am

    #1748893

  • RE: Random values

    Steve Jones - SSC Editor (9/29/2014)

    You can qualify with the full table name.

    I find that to be incredibly annoying to read in a query, especially when I have tables 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)

    September 29, 2014 at 11:23 am

    #1748889

  • RE: Random values

    edwardwill (9/29/2014)

    Thanks Jeff. I'll ponder and see if I prefer your way to my way. As someone once remarked, for each expert there's an equal and opposite expert...

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

    September 29, 2014 at 11:19 am

    #1748888

  • RE: Random values

    edwardwill (9/29/2014)

    Jeff Moden (9/29/2014)

    Heh... I'm interested to know how or why you came up with this coding standard of generally avoiding aliases. I did my degree in the school...

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

    September 29, 2014 at 7:54 am

    #1748821

  • RE: Random values

    edwardwill (9/29/2014)

    Hugo Kornelis (9/26/2014)

    ... my personal coding standard is to always use aliases for all tables in queries that use two or more tables, but use no alias in single-query...

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

    September 29, 2014 at 6:09 am

    #1748779

Viewing 15 posts - 22,696 through 22,710 (of 59,102 total)