Forum Replies Created

Viewing 15 posts - 26,911 through 26,925 (of 59,101 total)

  • RE: How to copy a table structure and data to a different server?

    The script that generates out as individual INSERT scripts is going to be comparatively and, maybe, horribly slow. With that thought in mind, I recommend doing the right click...

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

    April 29, 2013 at 6:11 pm

    #1611055

  • RE: Extract Speed from DB2

    David.Lester (4/29/2013)

    Jeff, you always manage to give me such surprising answers.

    Battery, hmm, now to find out in the IT hierarchy of this place, whom could check and tell me...

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

    April 29, 2013 at 4:41 pm

    #1611048

  • RE: How To Avoid The Duplicate Records....

    sarwaanmca (4/29/2013)

    hi Friends..

    i got the Result ...

    Select EmpID,EmpName,Department,max(Age),MAX(salary) from

    EmployeeDet

    group by EmpID,EmpName,Department

    Thanks for Your valuable Guidance

    Regards,

    Saravanan.D

    That will give you single rows but it will not give you the latest value...

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

    April 29, 2013 at 4:39 pm

    #1611047

  • RE: Suppressing output from a stored procedure.

    opc.three (4/26/2013)

    A proper solution would be to get rid of the use of xp_cmdshell all together.

    The recommended way using either a SQL Agent job or a web service 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)

    April 29, 2013 at 12:56 pm

    #1610964

  • RE: Extract Speed from DB2

    I guess I'll ask a similar question on these thread. Is there any way to bulk export data from DB2 to a Tab delimited file? One of 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)

    April 29, 2013 at 12:52 pm

    #1610960

  • RE: Extract Speed from DB2

    We have the same problem. A SELECT directly from a linked server is absolutely horrible. For some reason, an OPENROWSET through the same linked server worked a lot...

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

    April 29, 2013 at 12:48 pm

    #1610956

  • RE: SSIS 2008 - renaming files

    I can't help here because I don't use SSIS. A thoughtful but simple DOS "rename" would do this, though.

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

    April 29, 2013 at 12:44 pm

    #1610952

  • RE: Renaming system databases

    IT researcher (4/29/2013)

    The only reason to rename the file is for automated backup. I do have my own backup application where I can automate backup on daily,weekly or monthly...

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

    April 29, 2013 at 12:41 pm

    #1610949

  • RE: huge log file

    zi (4/26/2013)

    (you may have to run a checkpoint or two before the log rolls over to the free space to allow shrinking) will work,

    how to run a checkpoint?

    Thanks

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

    April 29, 2013 at 12:36 pm

    #1610948

  • RE: How To Avoid The Duplicate Records....

    This is a test for normalization and, I agree. It looks a lot like homework.

    First, you should never ever store age in a database. It can go out...

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

    April 29, 2013 at 12:32 pm

    #1610947

  • RE: SQL to XML

    Heh... by the same token (pun intended), considering the tag bloat of XML, I'm still fasciated that anyone would actually use it especially for such flat 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)

    April 29, 2013 at 9:52 am

    #1610884

  • RE: Random number generator

    Ah, apologies. I didn't understand what you were getting at. I see what you're saying now.

    The singleton formula can be easily modified to take min/max parameters as follows...

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

    April 29, 2013 at 6:36 am

    #1610766

  • RE: Random number generator

    Cindy Conway-312336 (4/26/2013)

    The simple update statement you listed is great too, but it looses the ability to specify a lower and upper range to the random numbers.

    Thanks for the feedback,...

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

    April 29, 2013 at 6:24 am

    #1610760

  • RE: Why powershell?

    opc.three (4/26/2013)

    Sergiy (4/26/2013)

    opc.three (4/26/2013)

    A stand-alone PowerShell prompt on Homer's machine does not offer much over a stand-alone CmdShell prompt on Homer's machine in the way of added security, only in...

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

    April 26, 2013 at 8:39 pm

    #1610555

  • RE: Need Split delimiter string into columns Solution

    gauravupadhyay2009 (4/26/2013)

    Thanks a lot for writing this wonderful SQL Code. it gave me relax that i could not get 2 days.

    i used this code in BULK Insert from .txt file...

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

    April 26, 2013 at 9:24 am

    #1610430

Viewing 15 posts - 26,911 through 26,925 (of 59,101 total)