Forum Replies Created

Viewing 15 posts - 31,831 through 31,845 (of 59,102 total)

  • RE: table performance

    I don't see any huge problems with that DDL that may cause INSERTs or SELECTs to be so slow. That pretty much isolates things to the code doing 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)

  • RE: To change datetype varchar(14)

    Cadavre (11/29/2011)


    But I prefer CLR when I have to do something like this. The RegEx function in .Net is much faster at validating this sort of thing (I'll knock 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)

  • RE: To change datetype varchar(14)

    rashid_alavi (11/29/2011)


    hi All,

    I Dont want to change on the DB , i want to have that display as YYYY/MM/DD when i want to generate reports for the application reports, 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)

  • RE: table performance

    znkin (11/28/2011)


    Thanks all for the replies...

    Apart from what was suggested by all would it help if I made a view and transferred all data in a separate table for 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)

  • RE: Enable autogrowth for databases in SQL Server

    beejug1983 (11/27/2011)


    Hi,

    I have to enable autogrowth for around 150+ databases on SQL Server 2005. This is client requirement. I know it is possible by using powershell script in one hit....

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

  • RE: Enable autogrowth for databases in SQL Server

    bruce 1565 (11/28/2011)


    This is for one server and includes system databases but I expect you know how to change to your requirements. The single commented lines are where you...

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

  • RE: Need to format HH:MM:SS

    stevefromOZ (11/27/2011)


    @jeff - i think you meant SSRS not SSIS, but heck, there's reasons to not like either on any given day :):hehe:

    They're all 4 letter words to 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)

  • RE: Little Love Lost for SMO

    Peter Schott (11/28/2011)


    And Jeff, MS is trying to give us job security again. Remember when SQL Server was so easy it didn't need a DBA? πŸ˜‰

    Heh... yup. Now you...

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

  • RE: Maximum Insert Commit Size

    Thanks for the feedback, SonTac.

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

  • RE: Stress – It’s Not Fair

    TravisDBA (11/28/2011)


    Great article Andy! I am also reminded of great saying in our business that I use all the time to throw the stress back into their (BA's and PM's)...

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

  • RE: Get Dates of Month listed as Columns

    vani_r14 (11/28/2011)


    There is nothing in common between these two tables

    The Client Details table MUST have something in it that can be referred to by date or can be joined 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)

  • RE: To find freespace of Database using a query

    bfranklin-557019 (12/7/2007)


    ----The following will return each local drive and a free space in MBEXEC master.dbo.xp_fixeddrives

    ----The following function with obtain a supplied drive's capacity

    ALTER FUNCTION [dbo].[fnDBDriveStats_GetDriveSize]

    (@cDrive char(1))...

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

  • RE: Need to format HH:MM:SS

    I guess that might be yet another reason for me to dislike SSIS. It's a whole lot simpler in T-SQL.

    SELECT CONVERT(VARCHAR(10),DATEDIFF(hh,0,DATEADD(ss,SecondsColumn,0)))

    + RIGHT(CONVERT(CHAR(8),DATEADD(ss,SecondsColumn,0),108),6)

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

  • RE: What else have you done?

    BWAA-HAAA!!!! I'm doing the same things as I did before... shoveling manure in a rose garden and feeding people things they sometimes have no taste for. πŸ˜›

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

  • RE: To change datetype varchar(14)

    rashid_alavi (11/27/2011)


    Dear All,

    i have column in my table which of datatype varchar(14) (20111107070115) , now i want to change display

    2011/11/07 07:01:15 ( DD/MM/YYYY HH:MM:SS)

    please help me on 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)

Viewing 15 posts - 31,831 through 31,845 (of 59,102 total)