Forum Replies Created

Viewing 15 posts - 18,796 through 18,810 (of 59,098 total)

  • RE: Where Do Staging Tables Belong

    lmarkum (12/29/2015)

    Definitely helpful feedback and it assures me that I was on the right path I just needed to confirm that if possible.

    As for the use of SSIS, I encouraged...

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

    December 29, 2015 at 9:41 am

    #1848541

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/29/2015)

    Jeff Moden (12/29/2015)

    I rather like the mostly unedited type of articles that are posted on SQLServerCentral. As a regular working Joe-bag-o-dunuts, I don't have a whole 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)

    December 29, 2015 at 9:27 am

    #1848538

  • RE: Send email from T-SQL

    mw112009 (12/29/2015)

    i am not a dba

    I'll still post the code but, do yourself a real favor to keep your butt out of the sling... ask your DBA if it's alright...

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

    December 29, 2015 at 9:21 am

    #1848534

  • RE: Shrink Database

    david.holley (12/29/2015)

    Before I posted, I googled around and found a good many articles/posts that basically said to 'Never, never, never, never' shrink the file because of what it does 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)

    December 29, 2015 at 9:13 am

    #1848533

  • RE: Shrink Database

    simon-hulse (12/29/2015)

    The option is there because sometimes you do need to shrink a DB. Like in your circumstances where you are deleting 6 months (I think it was) of logs...

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

    December 29, 2015 at 9:12 am

    #1848530

  • RE: Another XML explicit problem

    kenksoftware (12/28/2015)

    we are not even sure if these fields are ever going to be used in the future and there are hundreds of them which is why I'm stuffing them...

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

    December 29, 2015 at 9:08 am

    #1848526

  • RE: Syntax help on how to create a rule

    kaza_rohan (12/28/2015)

    Check:

    Check limits the values that are accepted by one or more columns.

    The Below code accepts only values A or k or R or S, it will not accept other...

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

    December 29, 2015 at 8:54 am

    #1848521

  • RE: Send email from T-SQL

    Lowell (12/29/2015)

    Jeff Moden (12/28/2015)

    mw112009 (12/28/2015)

    (:-P I will run it and findout whether our server is configured correctly to send email)

    If it turns out to not be setup and no...

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

    December 29, 2015 at 8:43 am

    #1848517

  • RE: Send email from T-SQL

    simon-hulse (12/29/2015)

    1. you need to give permissions to the user that is attempting to send the mail. This is in the MSDB database, role "DatabaseMailUserRole"

    Gosh no. Unless you're talking...

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

    December 29, 2015 at 8:32 am

    #1848511

  • RE: Send email from T-SQL

    mw112009 (12/29/2015)

    Yes I need the trick

    Are you the DBA for the company?

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

    December 29, 2015 at 8:30 am

    #1848510

  • RE: Where Do Staging Tables Belong

    Also and not to be a contrarian to anything posted thus far... just explaining a different method... we don't do DR for staging databases and we don't even bother backing...

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

    December 29, 2015 at 8:28 am

    #1848507

  • RE: Are the posted questions getting worse?

    I rather like the mostly unedited type of articles that are posted on SQLServerCentral. As a regular working Joe-bag-o-dunuts, I don't have a whole lot of time to go...

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

    December 29, 2015 at 8:20 am

    #1848503

  • RE: Shrink Database

    simon-hulse (12/29/2015)

    hmm..

    I have just run a shrink file and a shrink file with reorganise on a 30Gb database. The DB has lots of indexes. Just checking a couple... (both Clustered...

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

    December 29, 2015 at 8:10 am

    #1848502

  • RE: Shrink Database

    david.holley (12/29/2015)

    I do find it interesting that the gut reaction is no giving the potential impact to Indexes, but a part of me can't help but wonder if normal monitoring...

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

    December 29, 2015 at 7:32 am

    #1848487

  • RE: Where Do Staging Tables Belong

    lmarkum (12/28/2015)

    SoHelpMeCodd (12/28/2015)

    I do understand your perspective about not using resources on the OLTP instance for SSIS. I may consider moving things around so I could have SSIS 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)

    December 29, 2015 at 7:26 am

    #1848483

Viewing 15 posts - 18,796 through 18,810 (of 59,098 total)