Forum Replies Created

Viewing 15 posts - 22,606 through 22,620 (of 59,067 total)

  • RE: Best way to insure proc makes it

    I guess my question would be, why aren't you running this from the external server instead of having to use DTC?

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

    October 13, 2014 at 7:42 am

    #1751983

  • RE: Standard Edition - SORT_IN_TEMPDB

    DBA_Learner (10/13/2014)

    That's great. Thank you for information.

    Also, since my server is of Standard edition and not having any RCSI enabled or having Index rebuild ONLINE option, installing below hot fix...

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

    October 13, 2014 at 7:37 am

    #1751981

  • RE: Log Shipping Files getting huge and difficult to transfer

    alejandro-jasso (10/8/2014)

    Hi,

    Currently I have 2 SQL 2008 Standard Edition servers with one DB that is configured to do log shipping between them. These 2 servers are is same network so...

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

    October 12, 2014 at 9:44 pm

    #1751895

  • RE: xp_cmdshell / file level permissions

    Jason Shadonix (10/12/2014)

    I share your concerns, and appreciate you pointing this out, but unfortunately (as I'm sure you experts know) there are some cases where we have no choice but...

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

    October 12, 2014 at 8:42 pm

    #1751892

  • RE: find if log backup can be run

    Mad-Dog (10/12/2014)

    Hi,

    if i set database from full recovery into simple and then back to full recovery i can't run the TLog backup until i run Full or Diff DB backup.

    what...

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

    October 12, 2014 at 2:09 pm

    #1751886

  • RE: The wisdom of developers

    sqldriver (10/12/2014)

    Jeff Moden (10/12/2014)

    sqldriver (10/9/2014)

    They insisted something was wrong and that it was always faster. I told them to come back when they found it faster their way.

    That's kind...

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

    October 12, 2014 at 1:54 pm

    #1751884

  • RE: xp_cmdshell / file level permissions

    @jason,

    Don't do it the way you're doing it. YOU MUST NOT GRANT NON-SYSTEMADMINS PRIVS TO RUN XP_CMDSHELL DIRECTLY!!! Please, please, PLEASE! For the good of yourself and...

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

    October 12, 2014 at 10:34 am

    #1751873

  • RE: Standard Edition - SORT_IN_TEMPDB

    DBA_Learner (10/11/2014)

    I got SQL Standard edition of version 2008R2 with a large database table. Initally, when I used to run below index fragmentation script from Microsoft [http://msdn.microsoft.com/en-us/library/ms188917%28v=sql.105%29.aspx], I see after...

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

    October 12, 2014 at 9:58 am

    #1751871

  • RE: smtp mail

    p.s. And, not to be insulting in any way, shape, or form, if you don't know what the product called "Books Online" actually is, please post back. It'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)

    October 12, 2014 at 9:46 am

    #1751869

  • RE: smtp mail

    ramana3327 (10/12/2014)

    Hi All,

    I need to find when we did subscription, why the person didn't receive email.

    How to find the ssrs report emails are working?

    When we subscribed the report it will...

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

    October 12, 2014 at 9:44 am

    #1751868

  • RE: xp_cmdshell / file level permissions

    Jason Shadonix (10/11/2014)

    I am trying to get the following script to run on a newly created SQL server.

    I've set up the xp_cmdshell proxy account to be the same account as...

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

    October 12, 2014 at 9:40 am

    #1751867

  • RE: The wisdom of developers

    sqldriver (10/9/2014)

    They insisted something was wrong and that it was always faster. I told them to come back when they found it faster their way.

    That's kind of a big...

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

    October 12, 2014 at 9:19 am

    #1751866

  • RE: trigger

    I wouldn't use a trigger for this (especially since you've not used triggers before). A trigger would be "spaghetti code" where you throw something against the wall to see...

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

    October 12, 2014 at 9:05 am

    #1751865

  • RE: Defrag MASTER and MSDB

    I've never defragged either but there's nothing in Books Online under "Restrictions" when you lookup either database that says you can't.

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

    October 11, 2014 at 10:08 am

    #1751807

  • RE: Update ID in the table

    jacksonandrew321 (10/11/2014)

    Thanks Eiriksson for ur reply. I wasn't familiar with this id update.

    This kind of information is available in a tool called "Books Online". It's the "Help" system 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)

    October 11, 2014 at 9:32 am

    #1751804

Viewing 15 posts - 22,606 through 22,620 (of 59,067 total)