Forum Replies Created

Viewing 15 posts - 901 through 915 (of 7,164 total)

  • RE: help with sp_MsForEachDb

    jasona.work (7/5/2013)


    opc.three (7/5/2013)


    jasona.work (7/5/2013)


    might work.

    It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan...

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

  • RE: help with sp_MsForEachDb

    jasona.work (7/5/2013)


    might work.

    It might. Or it might randomly skip databases. sp_MsForEachDb is fatally flawed and although Microsoft seems happy enough to employ it within their own Maintenance Plan code, it...

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

  • RE: help with sp_MsForEachDb

    If you like sp_msforeachdb you should read this:

    A more reliable and more flexible sp_MSforeachdb

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

  • RE: Using snapshots for reporting on historical data?

    Database Snapshots are per database. I would not rely on them for historical reporting mainly because of the recurring need to create and retain additional snapshots. For every snapshot in...

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

  • RE: Online Indexing Being Blocked

    Denesh Naidoo (7/3/2013)


    Hi All,

    Running SQL Server 2008 R2 Enterprise Edition. The environment runs 24/7

    Had a normal indexing job...but this was obviously being blocked by user processes.

    Changed to Online Indexing...but...

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

  • RE: Managing Registered Servers

    D1rtyD0g (7/3/2013)


    Hi,

    I connect to SQL servers which are all hosted on a virtual environment.

    This virtual environment is not our on local network so we have to connect via IP &...

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

  • RE: SS2008Re: SQL JOB with xp_cmdshell Security related issue

    chauhanparixit (7/3/2013)


    Hi Friends,

    I have migrated SQL JOB from SQL2005 to SQL2008, as below

    THe step description as below

    IF EXISTS (SELECT * FROM someTable)

    BEGIN

    Exec master..xp_cmdshell "'c:\mypath\someExecutable.exe'"

    END

    this someExecutable.exe shoule create 4 image files...

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

  • RE: Today's Random Word!

    Readerless...Google Reader is no more :crying:

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

  • RE: Today's Random Word!

    Daniel Bowlin (7/2/2013)


    soaker

    joker

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

  • RE: Display More Than 8000 Characters (SQL Spackle)

    OK, now we're getting somewhere. So three replacements after the conversion to XML, and in a specific order to unwind the original encoding. Thanks for clarifying Solomon.

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

  • RE: Display More Than 8000 Characters (SQL Spackle)

    I think you have added an abstraction layer that seems to work but at the end of the day you still have an entitization problem:

    I think your approach has the...

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

  • RE: SQL Agent Job Rights - Best Advise

    This recent thread goes through it in pretty good detail.

    http://www.sqlservercentral.com/Forums/Topic1438841-1526-1.aspx

    Microsoft could do a better job exposing SQL Agent functionality to non-sysadmins by making some things possible while blocking others...

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

  • RE: Does this sound like a good place to enable "Optimize for ad-hoc workloads?"

    jasona.work (6/28/2013)


    I recently ran the "Server Dashboard" report on a new server here. Imagine my reaction to seeing Adhoc Queries sucking up ~75% of the cumulative CPU Usage and...

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

  • RE: Display More Than 8000 Characters (SQL Spackle)

    Solomon Rutzky (7/1/2013)


    1) XML datatype: This method requires doing 2 explicit REPLACE functions to translate less-than and ampersand characters into their XML-encoded values. The end result is an XML...

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

  • RE: SQLCMD hanging

    I am thinking this might be a PHP problem. From the EXEC() documentation:

    Note:

    If a program is started with this function, in order for it to continue running in the...

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

Viewing 15 posts - 901 through 915 (of 7,164 total)