Forum Replies Created

Viewing 15 posts - 16,531 through 16,545 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/12/2010)

    And that winner wasnt me... 🙁

    BUT, I did get a pretty good review at work for all the things I had achieved. 🙂

    A good review is quite worthwhile...

    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

    March 12, 2010 at 11:52 am

    #1132904

  • RE: How to get all the months between 2 dates

    Uncle Moki (3/12/2010)

    I solved a similar problem using a table-valued function that took two dates, used a while loop that iterates through the dates using DATEADD(...), and loaded each new...

    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

    March 12, 2010 at 11:42 am

    #1132900

  • RE: Error in DTA

    sandip.vs (3/12/2010)

    It worked if i select No Partitions

    Regards,

    Sandeep

    Good to hear.

    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

    March 12, 2010 at 11:39 am

    #1132898

  • RE: Error in DTA

    That means that the particular statement being referenced / evaluated from the stored proc does not reference any database tables. If there is a section of code that...

    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

    March 12, 2010 at 11:39 am

    #1132897

  • RE: Friday Afternoon

    sing4you (3/12/2010)

    We have yoga and t'ai chi classes here at work. Three lunch hours per week, I'm at one of those. I also get out and take a...

    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

    March 12, 2010 at 10:46 am

    #1132866

  • RE: Error in DTA

    Does it provide you with any other error? An error code or more detailed error-text would be very useful.

    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

    March 12, 2010 at 10:42 am

    #1132864

  • RE: New application seems to have wrecked a number of Sql Databases

    4data (3/12/2010)

    Hi all:

    Just thought I'd post this for info.

    I've sorted the issue out.

    I ended up going through the following document until the Sharepoint Services 2.0 Companyweb was completely removed....

    http://support.microsoft.com/kb/829114

    Then going...

    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

    March 12, 2010 at 10:36 am

    #1132861

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (3/12/2010)

    Ha! I'm far from 100% on the QOD. I'd like to say I'm testing wrong answers, which I do at times, but rarely. I tend 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

    March 12, 2010 at 9:37 am

    #1132824

  • RE: Anybody knows by chance if this book will be ever released?

    Grant Fritchey (3/12/2010)

    I think Jason was kidding on that one. But hey, the more posts with my book in them, the better.

    😀

    You mean like this?

    Steve Jones - Editor (3/12/2010)

    http://www.amazon.com/Server-Query-Performance-Tuning-Distilled/dp/1430219025/ref=sr_1_1?ie=UTF8&s=books&qid=1237206053&sr=8-1

    Yes -...

    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

    March 12, 2010 at 9:35 am

    #1132821

  • RE: Today's Random Word!

    Paul White (3/12/2010)

    Banana Hammock

    Chlorox - need to wash my eyes and mind's eye now.

    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

    March 12, 2010 at 9:31 am

    #1132817

  • RE: Today's Random Word!

    P90X

    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

    March 12, 2010 at 9:25 am

    #1132811

  • RE: Today's Random Word!

    tosscrosby-60625 (3/12/2010)

    CirquedeSQLeil (3/11/2010)

    tosscrosby-60625 (3/11/2010)

    sing4you (3/11/2010)

    Need any musicians? :w00t:

    Always!

    I can play my mp3's, does that count?

    If that's the case, I can spin some 45s or LPs (even a few cassettes)...

    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

    March 12, 2010 at 9:23 am

    #1132807

  • RE: Are the posted questions getting worse?

    Chad Crawford (3/12/2010)

    jcrawf02 (3/12/2010)

    that's what happens when you're chasing the guy in charge of the point totals---oops!:hehe:

    That was EXACTLY my thought too. Update AuthorPostCount SET Posts = Jeff+3000...

    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

    March 12, 2010 at 9:20 am

    #1132803

  • RE: Log Growing Pains

    george sibbald (3/12/2010)

    Jason, excellent article, in particular your second method for tracking growth. Thanks for taking the time to develop this and then share it with the community.

    In your SQL...

    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

    March 12, 2010 at 9:13 am

    #1132795

  • RE: Cast vs. Convert

    Paul White (3/12/2010)

    CirquedeSQLeil (3/12/2010)

    Hah - Paulpatine spinning like the MCP before Tron obliterates it with the disk - oh yeah.

    :laugh: You're getting worse...

    I know. Time for dba.sleep(8)

    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

    March 12, 2010 at 1:08 am

    #1132499

Viewing 15 posts - 16,531 through 16,545 (of 19,560 total)