Forum Replies Created

Viewing 15 posts - 17,761 through 17,775 (of 19,560 total)

  • RE: How to Save Login

    Ok. Makes sense. Good luck.

    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 28, 2010 at 12:11 pm

    #1110292

  • RE: Passed 70-450

    Congrats

    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 28, 2010 at 12:10 pm

    #1110291

  • RE: How to export hundreds of SSIS packages?

    One gotcha with the script as is, one will not be able to export packages specified with the "server storage". Use the encrypt action to change the protection level....

    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 28, 2010 at 11:41 am

    #1110269

  • RE: How to export hundreds of SSIS packages?

    ditto and done.

    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 28, 2010 at 11:32 am

    #1110259

  • RE: Database Engine Tuning Wizard recommendation for creating stats

    I would suggest getting to know how to read execution plans. Knowing how to read your execution plan can help you to understand index usage and indexes that may...

    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 28, 2010 at 11:10 am

    #1110250

  • RE: new to sql server 2005

    dianerstein (1/28/2010)

    thank you very much!

    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

    January 28, 2010 at 11:06 am

    #1110243

  • RE: Are the posted questions getting worse?

    GilaMonster (1/28/2010)

    CirquedeSQLeil (1/28/2010)

    We meet second Thursday of each month. Pacific Time zone.

    Same as Seattle? That puts you 10 hours behind me. So if you meet at 7pm, it'll 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 28, 2010 at 11:02 am

    #1110239

  • RE: Conflicting Information

    TheSQLGuru (1/28/2010)

    >>Do you have a suggestion on migrating to something else? Such as a sequential integer or something like that? What is more popular?

    Deciding on an indexing strategy 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

    January 28, 2010 at 11:00 am

    #1110237

  • RE: Query cost

    Gail Shaw actually covered this very topic in a blog post. In my first reply in this thread I included the link to that Post. It is 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

    January 28, 2010 at 10:55 am

    #1110233

  • RE: Query cost

    mark.ross (1/28/2010)

    Because the 'IN' clause, when run against a large number of rows could, potentially, return a large number of values to check against, whereas the 'EXISTS' clause should still...

    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 28, 2010 at 10:44 am

    #1110223

  • RE: How to Save Login

    sgambale (1/28/2010)

    I considered auditing successful logins, then reading the error log, but I prefer the other options which I think are easier in accomplishing what I want.

    Only failed logins 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

    January 28, 2010 at 10:43 am

    #1110221

  • RE: Are the posted questions getting worse?

    Once we get virtual meetings figured out for our chapter, I will be inviting the thread denizens to speak at our chapter. I volunteered to help line up some...

    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 28, 2010 at 10:41 am

    #1110218

  • RE: Are the posted questions getting worse?

    Jack Corbett (1/28/2010)

    We used LIve Meeting. If you are an official PASS Chapter you get an account for free. Contact Blythe Morrow at PASS HQ.

    Here's how...

    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 28, 2010 at 10:38 am

    #1110215

  • RE: Are the posted questions getting worse?

    Alvin Ramard (1/28/2010)

    (Tired of too many nested quotes so I'm starting a new post.)

    If a presenter was doing a LiveMeeting presentation for one PASS Chapter, is there any reason why...

    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 28, 2010 at 10:37 am

    #1110214

  • RE: Are the posted questions getting worse?

    GilaMonster (1/28/2010)

    CirquedeSQLeil (1/28/2010)

    I was thinking of suggesting this as a possibility for our chapter too. What do you use Jack (for remote presentations)? I imagine a webcam and...

    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 28, 2010 at 10:35 am

    #1110213

Viewing 15 posts - 17,761 through 17,775 (of 19,560 total)