TSQL 2012 #1

  • Comments posted to this topic are about the item TSQL 2012 #1

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thanks Ron for another one on SS-2012. Keep them pouring 🙂

    ~ Lokesh Vij


    Guidelines for quicker answers on T-SQL question[/url]
    Guidelines for answers on Performance questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (12/27/2012)


    Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

    +1

  • This was removed by the editor as SPAM

  • Koen Verbeeck (12/27/2012)


    Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

    I thought the explanation provided was sufficient, for after all it says:

    @include_browse_information

    @include_browse_information is type bit. If set to 1, each query is analyzed as if it has a FOR BROWSE option on the query. Returns additional key columns and source table information.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Koen Verbeeck (12/27/2012)


    Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

    +1

  • bitbucket-25253 (12/28/2012)


    Koen Verbeeck (12/27/2012)


    Nice question about a new feature, but your explanation could have mentioned the FOR BROWSE option. After all, that's what the question is about 🙂

    I thought the explanation provided was sufficient, for after all it says:....

    [/quote]

    Ron your explination only says:

    This dynamic management function takes an @object_id as a parameter and describes the first result metadata for the module with that ID.

    The Linked MSDN article has the text you quoted, not your explination..... 😛

  • Nice question with a good use of the new 2012 Adventure Works database.

  • 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

  • Nice easy question.

    The explanation is a bit sparse though, as Koen said.

    Tom

  • This is a straight-forward enough QOD, I suppose. But I do wonder what the point is of having the "Include_browse_information" switch to begin with. Why would MS think it necessary to provide a control for whether those five columns are populated in the results?

  • Fine learning... thank you for the question. (this is completely new for me) 🙂

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Thanks for the question..

  • Great question. Got to know about this DMV from this question. Got just 1 point but it was worth.

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply