Forum Replies Created

Viewing 15 posts - 2,281 through 2,295 (of 7,164 total)

  • RE: Does anyone have complete PDF/DOC on SQL Server replication ?

    Joy Smith San (1/21/2013)

    Hello,

    Does anyone have complete PDF/DOC on SQL Server replication ? Which includes configuration, scripts, monitoring etc; ? Of course I get everything from Microsoft web site, it's...

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

    January 21, 2013 at 10:29 pm

    #1579435

  • RE: high risk stystem stored procedures

    The list will be pretty much the same. As far as I can tell Microsoft is getting out of the business of producing new Extended Stored Procedures (XSPs) and moving...

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

    January 21, 2013 at 3:07 pm

    #1579392

  • RE: Converting MySQL Steps to SQL Server

    vuser (1/21/2013)

    I am installing a product which needs a database - it can use any database as long as there is a jdbc connector available for it. However, the installation...

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

    January 21, 2013 at 1:16 pm

    #1579365

  • RE: Run stored procedure when temp table is created/dropped

    I checked to be sure and DDL triggers FOR CREATE_TABLE do not fire when a global temp table is created. I do not know of way to accomplish what you're...

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

    January 21, 2013 at 10:26 am

    #1579325

  • RE: Is it possible to setup Resource Governor based on Always ON availability groups.

    You're welcome.

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

    January 21, 2013 at 8:43 am

    #1579284

  • RE: Is it possible to setup Resource Governor based on Always ON availability groups.

    It is, so you probably do not want to key off it unless that is only one of two applications that ever connect to the instance.

    You may want to...

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

    January 21, 2013 at 7:18 am

    #1579243

  • RE: Secondary indexes in SQL Server.

    OTF (1/21/2013)

    That would be an incorrect term for them.

    Nevertheless, it's a term I've seen used by some authors to explain the concepts of Indexes.

    I guess only the OP...

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

    January 21, 2013 at 7:14 am

    #1579240

  • RE: Have you used DQS in an actual production environment?

    Koen Verbeeck (1/21/2013)

    I do know there were a few performance issues when used in SSIS, but most of them have been solved by CU updates (and SP1 as well I...

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

    January 21, 2013 at 7:11 am

    #1579239

  • RE: Is it possible to setup Resource Governor based on Always ON availability groups.

    pelsebubb (1/21/2013)

    The difference is the applications, and as i said, i want to give the legacy/test AG less resources since those are not business criticall.

    I got that part. I am...

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

    January 21, 2013 at 7:07 am

    #1579237

  • RE: What process is consuming my VAS Reservation

    sqlserverdba1316 (1/20/2013)

    Thanks again for the reply...

    We don't have 3rd Party backup software as we are using Maintenance Plans for our backup. As with extended stored procedures also. ...

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

    January 21, 2013 at 7:01 am

    #1579233

  • RE: Have you used DQS in an actual production environment?

    I recently saw Brian Knight do a demo of DQS to cleanse name and address data and it looked useful and robust enough to try it out for real but...

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

    January 20, 2013 at 10:35 pm

    #1579085

  • RE: check traces

    sqlfriends (1/20/2013)

    Is there a way to find out what traces are enabled in a sql server instance?

    and also what is the default traces that are turned on?

    Thanks

    -- all traces

    SELECT *...

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

    January 20, 2013 at 10:32 pm

    #1579082

  • RE: What process is consuming my VAS Reservation

    Nothing is really standing out as holding onto a large amount of virtual memory at the moment. You can also have this issue if the VAS becomes fragmented and there...

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

    January 20, 2013 at 10:23 pm

    #1579081

  • RE: Declare error message before CATCH?

    SQLKnowItAll (1/18/2013)

    The developer mentioned that since this is a declarative language, the space had to be reserved no matter where it was. That seems correct, but I don't know...

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

    January 20, 2013 at 8:17 am

    #1579026

  • RE: sp_OAMethod

    You could also consider switching to use a Linked Server to connect to a remote SQL Server instead of using the OLE Automation routines.

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

    January 20, 2013 at 8:08 am

    #1579024

Viewing 15 posts - 2,281 through 2,295 (of 7,164 total)