Forum Replies Created

Viewing 15 posts - 22,666 through 22,680 (of 59,067 total)

  • 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

  • RE: Remove non alpha chars from a column

    dwain.c (9/29/2014)

    Jeff,

    You are correct. Adding that TYPE/value to the FOR XML is going to kill the performance of the string cleaner I posted. Which of course, I mistakenly...

    --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 5:57 am

    #1748773

  • RE: An Alternative (Better?) Method to UNPIVOT (SQL Spackle)

    dwain.c (9/28/2014)

    Stuart Pearson (9/26/2014)

    Hi, I just successfully ran this in SQL 2012 using a database at compatibility level 80!!

    Interesting. I wouldn't have thought that would be possible.

    What would be...

    --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 28, 2014 at 7:37 pm

    #1748699

  • RE: How to get ssns that occures in less than 12 month gap

    Why do people insist that it's ok to store SSNs in plain text?

    --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 28, 2014 at 5:45 pm

    #1748692

  • RE: Linked Server to AS400 Error Null Value

    Welsh Corgi (9/26/2014)

    I have a Stored Procedure that uses an Open Query to load a SQL Server Table.

    This is the Open Query part:

    SELECT *

    ...

    --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 28, 2014 at 12:02 pm

    #1748678

  • RE: Select case statement

    glarry (9/28/2014)

    Is it possible to use the result of case statement as Alias?

    Select date, case when age>20 then age End as Test+Age value

    No. Not unless you have some form...

    --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 28, 2014 at 11:33 am

    #1748677

Viewing 15 posts - 22,666 through 22,680 (of 59,067 total)