Forum Replies Created

Viewing 15 posts - 17,356 through 17,370 (of 19,560 total)

  • RE: Table name & Index name in finding Index fragmentation

    Try using OBJECT_Name(object_id)

    or you could join back to sys.objects for the table name.

    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 (2/13/2010)


    Paul White (2/13/2010)


    Alvin Ramard (2/13/2010)


    "Legacy apps, what does the backend really look like?" :w00t:

    ALVIN!!!!

    What?

    I bet you could find a youtube video of one 😀

    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: Can indexing be applied on Derived table?

    Tim Januario-145496 (2/13/2010)


    Based on the name of your column and the name of your table, this sounds like it should probably be the primary key. If it is, 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

  • RE: backup and Restore

    The restore will take longer. A restore will "zero" out the data file and grow it if necessary. Due to this kind of IO it should take longer...

    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: Where are you?

    lmu92 (2/13/2010)


    Jeff Moden (2/13/2010)


    ...

    A bit anti-American and a bit over the top in any case for any international forum such as this.

    Under the "given circumstances" (XXI. Olympic Winter Games...

    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: Today's Random Word!

    Utilities

    As in utility companies need real dba's.

    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?

    The thread needs redirection.

    Please no more plumbing in the thread.

    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

    Or do you mean:

    How to get alerted when SQL Server is restarted?

    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: Things to look for when planning for PASS 2010

    When do the tickets go on sale? I would like to attend.

    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: Things to look for when planning for PASS 2010

    When I registered, the price was under 1k and it was listed as being 1900 (they said 50% off).

    I would look especially to the networking. The information is good,...

    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: Today's Random Word!

    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

  • RE: Are the posted questions getting worse?

    lmu92 (2/12/2010)


    Es scheint, als ob nunmehr die jeweilige Muttersprache für Beiträge in "The Thread" genutzt wird. Ich bin mir nicht sicher, ob dadurch die Kommunikation vereinfacht wird... 😉

    Translation for those...

    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?

    Luke L (2/12/2010)


    CirquedeSQLeil (2/12/2010)


    GilaMonster (2/12/2010)


    CirquedeSQLeil (2/12/2010)


    Ok - Thread commandeered. Should we go all french all the time?

    Jy kan, maar ek nie Frans praat nie. Miskien sal ek Arikaans 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?

    GilaMonster (2/12/2010)


    CirquedeSQLeil (2/12/2010)


    Ok - Thread commandeered. Should we go all french all the time?

    Jy kan, maar ek nie Frans praat nie. Miskien sal ek Arikaans of isiZulu praat.

    As die...

    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?

    Roy Ernest (2/12/2010)


    Alvin Ramard (2/12/2010)


    Roy Ernest (2/12/2010)


    You all go french, I will go malayalam. (My language) ... 🙂

    Merry and Mary... Not much difference... 🙂

    hmmm, spell malayalam backwords

    You spotted it quite...

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