Forum Replies Created

Viewing 15 posts - 7,426 through 7,440 (of 19,560 total)

  • RE: All I want for Christmas

    I wouldn't mind some new power tools. Golf gear is nice too. But the best gift is my kids enjoying what they get.:cool:

    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

  • RE: Random Slowness in Insert statment

    Jeff Moden (12/22/2011)


    Ninja's_RGR'us (12/22/2011)


    Jeff Moden (12/21/2011)


    Aspet Golestanian Namagerdi (12/21/2011)


    Actually I stopped the Log shipping Backup job and also I disable the replication jobs but still every 10 minutes,slowness happens...

    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

  • RE: What is the meaning of WHERE *= COLUMN NAME

    GSquared (12/22/2011)


    SQLRNNR (12/21/2011)


    Those are the old non-ansi style Outer Join references. This was deprecated in SQL 2005. The upgrade advisor in 2005 will inform you of this joins...

    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

  • RE: Display Complex Hierarchical Data with Server-Side Pagination

    Nice work thanks. I added this to my briefcase for future reference.

    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

  • RE: Happy Holidays

    Woohoo - awesome steaks for the holidays

    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

  • RE: Triggers

    Thanks for the question.

    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

  • RE: Today's Random Word!

    Reindeer Steak

    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

  • RE: Are the posted questions getting worse?

    Happy Holidays to one and all.

    And to others, 10 SSC points for this reference:

    Why would I want anything with a mind of its own bobbing about between my legs?

    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

  • RE: Are the posted questions getting worse?

    jcrawf02 (12/21/2011)


    anybody watch Animaniacs? Reminds me of the one where they're talking to Einstein, and he's "calculating the speed of light" by pulling the chain on the lamp with one...

    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

  • RE: Today's Random Word!

    Ray K (12/21/2011)


    SQLRNNR (12/21/2011)


    relief

    R-O-L-A-I-D-S

    Tum Tum Tum Tum Tuuuuums

    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

  • RE: Today's Random Word!

    relief

    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

  • RE: Random Slowness in Insert statment

    Your replication speaks to the wait type ONDEMAND_TASK_QUEUE. It could also contribute to the occasional slowness.

    Blocking occurs within SQL Server. You will need to look in SQL to...

    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

  • RE: Date parameter...

    As the link indicates - you cannot without trying to do a .Net workaround.

    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

  • RE: What is the meaning of WHERE *= COLUMN NAME

    Those are the old non-ansi style Outer Join references. This was deprecated in SQL 2005. The upgrade advisor in 2005 will inform you of this joins and give...

    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

  • RE: Identify SQL Server Instances + User database

    If you don't have documentation stating what the servers are, then you will probably need a net admin to help you identify all of them. There are tools (sqlping2,...

    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

Viewing 15 posts - 7,426 through 7,440 (of 19,560 total)