Forum Replies Created

Viewing 15 posts - 33,076 through 33,090 (of 59,099 total)

  • RE: scramble data

    Ghanta (7/28/2011)

    Jeff Moden (7/28/2011)

    Ghanta (7/27/2011)

    Anyone has Procedure to scramble data like addresses, but the new data should not be any characters... address1 should look like address1 field and so on?...

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

    July 28, 2011 at 6:46 pm

    #1360517

  • RE: Split Column

    Thanks for the feedback, Rocky.

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

    July 28, 2011 at 5:37 pm

    #1360505

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (7/28/2011)

    Jeff Moden (7/27/2011)

    Steve Jones - SSC Editor (7/27/2011)

    I don't control the announcement. I assume it will be a business day or two afterward.

    From the website......

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

    July 28, 2011 at 5:16 pm

    #1360500

  • RE: Red Gate Data Generator

    sindhigrl (7/28/2011)

    Jeff, I can install Adventure works on my test server. Thanks for your help!

    That'll work great. Adventure works as a table in it with over 19,000 bogus addresses...

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

    July 28, 2011 at 2:16 pm

    #1360453

  • RE: CPU utilization is 100%

    Lavanyasri (7/28/2011)

    HI Jeff ,

    You have any idea how to find two servers in the same domain . ??

    I sure don't... that's part of the problem. I normally...

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

    July 28, 2011 at 10:21 am

    #1360291

  • RE: Red Gate Data Generator

    sindhigrl (7/28/2011)

    Yes, I'm trying to scramble the prod data in the test/dev environment. Is this the wrong way to go about this?

    Nope. Not wrong. This can be done...

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

    July 28, 2011 at 10:08 am

    #1360281

  • RE: store procedure

    {edit} sorry, wrong post.

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

    July 28, 2011 at 7:44 am

    #1360100

  • RE: scramble data

    Ghanta (7/27/2011)

    Anyone has Procedure to scramble data like addresses, but the new data should not be any characters... address1 should look like address1 field and so on? Thanks!

    Will using one...

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

    July 28, 2011 at 7:09 am

    #1360062

  • RE: Converting a single row into Multiple rows

    SQLMAIN (7/28/2011)

    I am on SS2000.... Any solution that will work here.

    Thanks

    Yes... there is a solution. Some very important high performance improvements have been made in the last couple 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)

    July 28, 2011 at 6:55 am

    #1360044

  • RE: Converting a single row into Multiple rows

    LutzM (7/27/2011)

    Search this site for "DelimitedSplit8k" (Rev 06 is the current version AFAIK).

    The following query will return the expected result

    SELECT c.name, ID = LTRIM(split.Item)

    FROM MULT_VALS c

    CROSS APPLY dbo.DelimitedSplit8k(c.IDS,',') split

    This...

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

    July 28, 2011 at 6:50 am

    #1360038

  • RE: Looping in SQL Server 2008

    If you really want some good help, please see the first link in my signature line below. If you can provide the data in a manner cited in that...

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

    July 28, 2011 at 6:46 am

    #1360033

  • RE: CPU utilization is 100%

    Ninja's_RGR'us (7/28/2011)

    Lavanyasri (7/28/2011)

    Thanks.

    The two Ip's are different and two machine names are different .

    You have any idea how to find these two servers in the same domain ....

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

    July 28, 2011 at 6:17 am

    #1360002

  • RE: CPU utilization is 100%

    Luck may have something to do with it, Remi. I've never had any luck at running OSQL (old days) or SQLCMD when two SQL Server instances were named precisely...

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

    July 28, 2011 at 6:09 am

    #1359989

  • RE: Split Column

    Ok, Rocky... here's some "starter" code that does what you want with the data you posted (see the first link in my signature line below for how to post 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)

    July 28, 2011 at 5:59 am

    #1359973

  • RE: CPU utilization is 100%

    Lavanyasri (7/27/2011)

    HI All,

    Thanks in Advance .

    We have one preprod and production server . All the time the CPU Utilization is 100% on production server . We...

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

    July 27, 2011 at 9:13 pm

    #1359788

Viewing 15 posts - 33,076 through 33,090 (of 59,099 total)