Forum Replies Created

Viewing 15 posts - 2,956 through 2,970 (of 19,560 total)

  • RE: Keyboard key to Toggle between query and results pane

    Thanks for the question.

    The options of fn+f6 and shft+f6 are great for toggling between the query, messages, and results tabs.

    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: Keyboard key to Toggle between query and results pane

    rhythmk (5/30/2014)


    Thanks Hardik for question.

    However with the introduction of new keyboard having fn key in place.Microsoft should also change their documentation.

    As here it would be (fn + f6) key...

    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!

    Sean Lange (5/30/2014)


    crookj (5/30/2014)


    Ed Wagner (5/30/2014)


    Stuart Davies (5/30/2014)


    Sean Lange (5/29/2014)


    SQLRNNR (5/29/2014)


    Sean Lange (5/29/2014)


    Ed Wagner (5/29/2014)


    SQLRNNR (5/29/2014)


    Sean Lange (5/29/2014)


    SQLRNNR (5/29/2014)


    Sean Lange (5/29/2014)


    Ed Wagner (5/29/2014)


    Sean Lange (5/29/2014)


    Ed Wagner (5/29/2014)


    Sean Lange (5/29/2014)


    Stuart Davies...

    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: uses of string splitters

    Sean Lange (5/30/2014)


    Luis Cazares (5/29/2014)


    Sean Lange (5/29/2014)


    Here is an example of a real world case for using a splitter. This iTVF will return a string with the proper case. 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

  • RE: Joining two tables and dealing with null values

    Well, at least it is working.

    I find it odd that nobody was interested in Sean's points on ebay. Seems very uneducated or crass of people - sheesh.

    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: Farewell

    paul.goldstraw (5/30/2014)


    SQLRNNR (5/29/2014)


    Have some fun and enjoy the opportunity.

    On the side, will you be back June 14th or July 14th?

    He must mean July as SQLBits is July 17th, either 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: Farewell

    crmitchell (5/30/2014)


    He's clearly testing Redgate's new temporal compression module for the toolbelt.

    How else are we expected to provide solutions yesterday for the tasks we won't get a spec for until...

    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: Farewell

    GilaMonster (5/30/2014)


    SQLRNNR (5/29/2014)


    Have some fun and enjoy the opportunity.

    On the side, will you be back June 14th or July 14th?

    If Steve's managed to squeeze a 6 week break into 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

  • RE: TableVariable Update

    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: TableVariable Update

    Try this instead

    update m

    SET LatestDate=B.LatestDate

    FROM TableB B

    INNER JOIN @Mytabvar m

    ON m.id=B.ID

    This is completely untested not having any table definitions and so forth.

    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: Farewell

    Have some fun and enjoy the opportunity.

    On the side, will you be back June 14th or July 14th?

    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: Just curious, what are your SQL pet peeves ?

    mister.magoo (5/29/2014)


    Databases that have been restored to a new database name, but the logical file names have not been changed.

    INSERTS without columns specified.

    Pages and pages of commented out code (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

  • RE: SSPI handshake failed...

    There are some steps to resetting the SQL spns in that 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

  • RE: uses of string splitters

    KoldCoffee (5/29/2014)


    it's a no good link

    link works for me

    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: uses of string splitters

    Luis Cazares (5/29/2014)


    Sean Lange (5/29/2014)


    Here is an example of a real world case for using a splitter. This iTVF will return a string with the proper case. I did 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

Viewing 15 posts - 2,956 through 2,970 (of 19,560 total)