Forum Replies Created

Viewing 15 posts - 6,901 through 6,915 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Lynn Pettis (2/7/2012)

    Now that it is officially posted on facebook, I can start telling everyone.

    Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson Matthew was born at...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 2:35 pm

    #1444145

  • RE: Help with a query.

    Are you trying to throw this into a loop?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 2:34 pm

    #1444143

  • RE: JDBC adapter cannot log into named instance of SS2008R2

    Nope. I have used different ports.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 2:33 pm

    #1444141

  • RE: selet buyer and seller in one table at the same time

    This should help you start figuring it out.

    SELECT a.Personname AS Buyer, b.PersonName AS Seller,a.transactionnum

    FROM sometable a

    INNER JOIN sometable b

    ON a.transactionnum = b.transactionnum

    WHERE a.personnametype = 'buyer'

    AND b.personnametype = 'seller'

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 1:50 pm

    #1444115

  • RE: JDBC adapter cannot log into named instance of SS2008R2

    I think you will be better using a static port. I have seen it work better with JDBC to use a static port when dealing with named instances.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 1:44 pm

    #1444110

  • RE: Activity Monitor - Category Does Not Exist

    I think it is more related to the Central management server and it being RTM. Let us know how the patching goes.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 1:26 pm

    #1444100

  • RE: Is it Possible to pass parameters from one Job step to another?

    Are you referring to a sql agent job step?

    Without building some sort of support system (tables etc) to record parameter values at the end of each step, the agent does...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 12:12 pm

    #1444039

  • RE: Data Replication, Mirroring, Log Shipping

    If the users cannot be interrupted by the log restores, then use transactional replication.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 12:11 pm

    #1444038

  • RE: INSERT INTO versus SELECT INTO data import strategy

    Does the application require that it be xml in order to use that info? It seems like a backwards way of doing this to me. You receive the...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 12:06 pm

    #1444035

  • RE: Today's Random Word!

    words with friends

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 11:13 am

    #1443997

  • RE: change the allocation unit size and partition offset of the drives on active active node clusters

    Perry Whittle (2/7/2012)

    sql2k8 (2/7/2012)

    with the minimal impact on the current running cluster

    There is no minimal impact. To change these you must delete and re create the partitions, period.

    Agreed - no...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 11:12 am

    #1443996

  • RE: Help with a query.

    Adi Cohn-120898 (2/7/2012)

    Hope that I undestood what you need:

    DECLARE @data table (n INT)

    INSERT @data

    SELECT 1 UNION ALL

    SELECT 10 UNION ALL

    SELECT 11 UNION ALL

    SELECT 12 UNION ALL

    SELECT 13 UNION ALL

    SELECT...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 11:09 am

    #1443994

  • RE: INSERT INTO versus SELECT INTO data import strategy

    Do you have any control on the xml that is coming to you?

    We had a case where the app was creating the xml for us to consume in the database...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 11:06 am

    #1443992

  • RE: Help with a query.

    Try this

    DECLARE @data table (n varchar(2))

    INSERT @data

    SELECT 1 UNION ALL

    SELECT 10 UNION ALL

    SELECT 11 UNION ALL

    SELECT 12 UNION ALL

    SELECT 13 UNION ALL

    SELECT 14 UNION ALL

    SELECT 15 UNION ALL

    SELECT 16...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 11:02 am

    #1443989

  • RE: Activity Monitor - Category Does Not Exist

    are there other servers being managed by this central server that are > SQL Server 2008 RTM? My first recommendation would be to get that server patched.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    February 7, 2012 at 10:51 am

    #1443976

Viewing 15 posts - 6,901 through 6,915 (of 19,560 total)