Forum Replies Created

Viewing 15 posts - 8,161 through 8,175 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Fal (10/19/2011)

    GilaMonster (10/18/2011)

    There goes the Thread for the night.

    What? Just one night? I'm gone for a couple of days and come back to find the thread dominated by...

    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

    October 19, 2011 at 4:21 pm

    #1397013

  • RE: database file size growing but rows / tables not

    mwagner 55444 (10/19/2011)

    SQLRNNR (10/19/2011)

    It looks to be a need to End the Conversation (service broker).

    Check this thread and see what they did.

    http://serverfault.com/questions/235327/mssql-2008r2-service-broker-initiator-queue-filled-with-old-conversations

    That is the exactly the problem, I've got something...

    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

    October 19, 2011 at 2:27 pm

    #1396961

  • RE: database file size growing but rows / tables not

    It looks to be a need to End the Conversation (service broker).

    Check this thread and see what they did.

    http://serverfault.com/questions/235327/mssql-2008r2-service-broker-initiator-queue-filled-with-old-conversations

    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

    October 19, 2011 at 1:54 pm

    #1396938

  • RE: database file size growing but rows / tables not

    mwagner 55444 (10/19/2011)

    I think this may have helped:

    sysdercv ...

    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

    October 19, 2011 at 1:24 pm

    #1396921

  • RE: Tally Table vs. While loop

    Sometimes that little bit of extra info is enough to tell the optimizer a better plan to choose. That appears to be the case here. Posting the execution...

    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

    October 19, 2011 at 11:47 am

    #1396841

  • RE: database file size growing but rows / tables not

    Ninja's_RGR'us (10/19/2011)

    Ninja's_RGR'us (10/19/2011)

    SQLRNNR (10/19/2011)

    Run the scripts for parts I and II from this article and let us know which script it correlates to in your server (of the two you...

    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

    October 19, 2011 at 11:20 am

    #1396818

  • RE: database file size growing but rows / tables not

    Run the scripts for parts I and II from this article and let us know which script it correlates to in your server (of the two you mentioned)

    http://jasonbrimhall.info/2010/05/25/space-used/

    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

    October 19, 2011 at 10:39 am

    #1396791

  • RE: Today's Random Word!

    Ninja's_RGR'us (10/19/2011)

    SQLRNNR (10/19/2011)

    Ninja's_RGR'us (10/19/2011)

    SQLRNNR (10/19/2011)

    Ninja's_RGR'us (10/19/2011)

    SQLRNNR (10/19/2011)

    Is that what your five finger reference meant?

    No, that was for stealing!

    Somebody stole your ring err pants?:-D

    Yes, you actually stole a quote I had...

    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

    October 19, 2011 at 10:31 am

    #1396785

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (10/19/2011)

    Stefan Krzywicki (10/19/2011)

    Brandie Tarvin (10/19/2011)

    Harold and Kumar get pantsed.

    Isn't that one of their actual movies at this point?

    Hey, I like Harold and Kumar. They entertain...

    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

    October 19, 2011 at 10:25 am

    #1396781

  • RE: Today's Random Word!

    Ninja's_RGR'us (10/19/2011)

    SQLRNNR (10/19/2011)

    Ninja's_RGR'us (10/19/2011)

    SQLRNNR (10/19/2011)

    Is that what your five finger reference meant?

    No, that was for stealing!

    Somebody stole your ring err pants?:-D

    Yes, you actually stole a quote I had posted 20...

    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

    October 19, 2011 at 10:22 am

    #1396775

  • RE: Today's Random Word!

    Ninja's_RGR'us (10/19/2011)

    SQLRNNR (10/19/2011)

    Is that what your five finger reference meant?

    No, that was for stealing!

    Somebody stole your ring err pants?:-D

    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

    October 19, 2011 at 10:02 am

    #1396759

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (10/19/2011)

    Be quick! before they run out of pants!

    Remi blacked out his phone number so we couldn't pants him.

    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

    October 19, 2011 at 10:01 am

    #1396757

  • RE: Today's Random Word!

    Ray K (10/19/2011)

    Ninja's_RGR'us (10/19/2011)

    I can't believe this hasn't come up yet.

    PANTS. 😀

    I thought about it, but I figured that it was already going on The Thread. No need...

    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

    October 19, 2011 at 9:53 am

    #1396746

  • RE: Today's Random Word!

    Ninja's_RGR'us (10/19/2011)

    Ray K (10/19/2011)

    crookj (10/18/2011)

    WOTD - enhancement

    Viagra

    Here's a handy way to have stock on hand!

    Is that what your five finger reference meant?

    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

    October 19, 2011 at 9:52 am

    #1396743

  • RE: Today's Random Word!

    Daniel Bowlin (10/19/2011)

    Brandie Tarvin (10/19/2011)

    Ray K (10/19/2011)

    crookj (10/18/2011)

    WOTD - enhancement

    Viagra

    Lyrica

    resume

    as in CV?

    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

    October 19, 2011 at 9:00 am

    #1396694

Viewing 15 posts - 8,161 through 8,175 (of 19,560 total)