Forum Replies Created

Viewing 15 posts - 17,806 through 17,820 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/27/2010)

    Oh, before I forget Jason, we passed on to our local chapter membership the link to your blog about user group participation. That should be required reading...

    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

    January 27, 2010 at 12:52 pm

    #1109533

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/27/2010)

    Lynn Pettis (1/27/2010)

    Alvin Ramard (1/27/2010)

    How nice it would be if getting answers from PASS was as simple as dealing with the OPs on here.

    One can only wish.

    Are 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

    January 27, 2010 at 12:33 pm

    #1109519

  • RE: Are the posted questions getting worse?

    In retrospect after looking at the name of the OP, I might reconsider whether there is a tarnished halo or not.

    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

    January 27, 2010 at 11:14 am

    #1109461

  • RE: Are the posted questions getting worse?

    Lynn Pettis (1/27/2010)

    Is my halo getting tarnished by such responses as this?

    Maybe just a bit.

    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

    January 27, 2010 at 11:13 am

    #1109460

  • RE: Ways to run large script files

    Jeff Moden (1/27/2010)

    No... heh... I've never seen a single script so large. As a side bar, you've just got to ask how someone tested it if it can be...

    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

    January 27, 2010 at 11:10 am

    #1109456

  • RE: Are the posted questions getting worse?

    Ray K (1/27/2010)

    Just curious: is anyone else besides me struck by the number of people asking about character-to-date conversions?

    There have been a rash of those. New semester started recently...

    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

    January 27, 2010 at 10:59 am

    #1109449

  • RE: Today's Random Word!

    Lynn Pettis (1/27/2010)

    CirquedeSQLeil (1/27/2010)

    Bumper Cars

    Would be more fun! 😉

    NASCAR OJT

    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

    January 27, 2010 at 10:58 am

    #1109447

  • RE: How do i decrypt encrypted stored procedure?

    the code is nice. I was just looking for the Internet Reference if you had it handy.

    Thanks

    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

    January 27, 2010 at 10:57 am

    #1109445

  • RE: DBCC Shrinkdb and fragmentation question

    Hmmm. Without instant initialization my experience has been that I save several hours on my restore jobs (300GB DBs) when restoring to a database where the files already exist....

    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

    January 27, 2010 at 10:56 am

    #1109442

  • RE: Today's Random Word!

    Bumper Cars

    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

    January 27, 2010 at 10:39 am

    #1109426

  • RE: Query cost

    Steve Jones - Editor (1/27/2010)

    I've awarded back all points and then changed the question to just have a right answer and wrong answer.

    Apologies. This one slipped by

    Thanks Steve - I...

    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

    January 27, 2010 at 9:38 am

    #1109389

  • RE: Query cost

    doh - double post

    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

    January 27, 2010 at 9:31 am

    #1109382

  • RE: Query cost

    Saurabh Dwivedy (1/27/2010)

    Kelsey Thornton (1/27/2010)

    CirquedeSQLeil (1/26/2010)

    if one examines execution plans for these two queries and run them together, the query optimizer treats them as the same execution plan and equates...

    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

    January 27, 2010 at 9:30 am

    #1109381

  • RE: ROW_NUMBER(): An Efficient Alternative to Subqueries

    Thanks for comparing the window function to the subquery. Nice article.

    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

    January 27, 2010 at 1:27 am

    #1109157

  • RE: Conflicting Information

    Some of what factors into the performance and which column to list first comes from the query and how it is written. Could you provide the query and 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

    January 27, 2010 at 1:12 am

    #1109153

Viewing 15 posts - 17,806 through 17,820 (of 19,560 total)