Forum Replies Created

Viewing 15 posts - 17,776 through 17,790 (of 19,560 total)

  • RE: Query cost

    mike.anderson 52709 (1/28/2010)


    mark.ross (1/28/2010)


    One of the reasons that the query plans are identical could be that the table being selected from in the 'IN' and 'EXISTS' clause is small. ...

    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?

    CirquedeSQLeil (1/28/2010)


    Jack Corbett (1/28/2010)


    Alvin Ramard (1/28/2010)


    CirquedeSQLeil (1/28/2010)


    Today is a Thread Gone Wild day - and I am still catching up.

    So will you pay for travel expenses of those denizens 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

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/28/2010)


    Alvin Ramard (1/28/2010)


    CirquedeSQLeil (1/28/2010)


    Today is a Thread Gone Wild day - and I am still catching up.

    So will you pay for travel expenses of those denizens that are...

    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?

    Lynn Pettis (1/28/2010)


    Rubberized crystal?? Must be, it keeps bouncing around the world! 😛

    It isn't green in color now is it?

    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?

    Alvin Ramard (1/28/2010)


    Gianluca Sartori (1/28/2010)


    Alvin Ramard (1/28/2010)


    FYI, you're all invited to come to Memphis in April to continue this discussion on SQL Injection.

    We normally meet on the 2nd Thursday of...

    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?

    Alvin Ramard (1/28/2010)


    Actually his comment may have been much nicer than we thought, thanks to his poor English.

    He may have meant that he has "read the books" and that is...

    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: Query Tuning

    You're welcome.

    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: How to get the deleted Records

    New questions should be posted to new threads.

    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: SQL Server 2000, 2005 and 2008 on same machine

    You're welcome.

    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: perfmon logging frequency

    It really depends on the performance counters being logged.

    Some only need to be logged daily, and some would be better to log every minute. Sometimes those that should 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

  • RE: Query Tuning

    Azzu (1/27/2010)


    Hi

    I have few questions regarding the captioned:

    1. Maximum/optimum number of joins to be used in a query.

    It Depends

    2. What are the different parameters that needs to be checked during...

    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: SQL Server 2000, 2005 and 2008 on same machine

    Default instance can be any of them.

    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: How to Save Login

    I have implemented something very similar. Rather than using event notifications and queues, we just used a logon trigger that performed the insert statement as in the article.

    The method...

    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: Bit by bit

    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: Arrogance Has No Place in Security

    Just before this story broke I watched a tv show depicting the very same thing. I thought it was quite the coincidence. The relationship between the two are...

    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 - 17,776 through 17,790 (of 19,560 total)