Forum Replies Created

Viewing 15 posts - 4,891 through 4,905 (of 7,164 total)

  • RE: SQL Server 2005 page life concern

    george sibbald (3/14/2012)

    that article is saying on a 32bit system AWE will allow you to address memory above 4GB for the buffer pool. Otherwise you are limited to either 2GB,...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 14, 2012 at 9:31 am

    #1459291

  • RE: how to make this batch file work using xp_cmdshell?

    sqldba_newbie (3/14/2012)

    Thanks..In my batch file i have set to restart the box itself after applying CU.

    That's a common practice. It is not usually necessary however I rarely oppose it when...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 14, 2012 at 9:21 am

    #1459282

  • RE: SQL 2005 Service Pack Updates

    You're welcome 🙂

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 14, 2012 at 9:00 am

    #1459256

  • RE: Parsing tab selimited text into SQL table

    Lisa Cherney (3/14/2012)

    If you need to do this from a .net application, load your data from the file into a DataTable and then use the SQLBulkCopy class (http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlbulkcopy.aspx) to move...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 14, 2012 at 8:58 am

    #1459252

  • RE: Service broker

    devanandiiway (3/14/2012)

    My question is do we have to disable the service broker by issuing the command alter database msdb set disable_broker.

    No. I have moved msdb with no problem without disbaling...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 14, 2012 at 12:25 am

    #1458994

  • RE: An Azure Outage

    In my experience the weakest managers are the ones repeatedly leading a witch-hunt for this or that...terrible for morale and very anti-progress.

    All moves have advantages and disadvantages. The cloud is...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 10:41 pm

    #1458980

  • RE: compare difference of versions of SSIS package

    Are you using a version control system to manage your SSIS packages?

    Are you deploying packages to the file system or to msdb?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 9:11 pm

    #1458976

  • RE: compare difference of versions of SSIS package

    Yes.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 8:22 pm

    #1458971

  • RE: Is it possible to recreate a package based on the one deployed to SQL Server?

    DTUtil.exe is what I use for exporting packages from servers. It's included in the client tools, available from the command-line.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 8:03 pm

    #1458968

  • RE: SSIS Validates each Data Flow when opening Solution - Delay Validation?

    Yes, you can set Delay Validation to true. The downside is you will not pickup on outdated metadata or broken connections until runtime.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 7:59 pm

    #1458967

  • RE: Parsing tab selimited text into SQL table

    Nary is the day when I am in an environment without an SSIS installation for use with ETL processing.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 7:49 pm

    #1458965

  • RE: DataBase Max Server Memory Setting

    opc.three (3/12/2012)

    You can change the max memory setting and it takes effect without requiring a restart.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 7:43 pm

    #1458963

  • RE: Parsing tab selimited text into SQL table

    Jeff Moden (3/13/2012)

    opc.three (3/13/2012)

    If you use SQL Agent, there is no need to introduce an additional programming domain into the call stack. Ditch xp_CmdShell and call bcp from a step...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 5:59 pm

    #1458945

  • RE: how to make this batch file work using xp_cmdshell?

    sqldba_newbie (2/19/2012)

    Ok i got this working,hope this would help someone.

    For SP's i haven't tried this because WSUS has the capability to deploy SP's.

    For CU's, you can make use of PowerShell...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 5:49 pm

    #1458943

  • RE: Need to configure Mail Feature

    If you never setup Database Mail then read this: Database Mail Configuration Wizard

    If you never configured SQL Agent to use Database Mail then read this: How to: Configure SQL Server...

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

    March 13, 2012 at 5:31 pm

    #1458938

Viewing 15 posts - 4,891 through 4,905 (of 7,164 total)