Using sys.index_columns

  • Comments posted to this topic are about the item Using sys.index_columns



    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]


    If you don't have time to do it right, when will you have time to do it over?

  • Good one, thanks

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • nice 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

  • A lot of reading, but a nice question which will certainly teach those who answer incorrectly.

    Thanks

    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]

  • bitbucket-25253 (12/19/2011)


    A lot of reading, but a nice question which will certainly teach those who answer incorrectly.

    Thanks

    +1 - thanks!

  • Nice question and I definately learned something, but quite an awful format 🙂

    (I had to copy paste each answer into SSMS so I could read it better)

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

  • Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best as I could. But the end-result is indeed terrible. Lesson learnt for a next time: put the options in the text and in the answer fields just ask for #1, #2, #3 or #4.



    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]


    If you don't have time to do it right, when will you have time to do it over?

  • R.P.Rozema (12/20/2011)


    Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best as I could. But the end-result is indeed terrible. Lesson learnt for a next time: put the options in the text and in the answer fields just ask for #1, #2, #3 or #4.

    That is indeed the best option. The formatting options for the question are adequate; for the answer options, formatting is non-existant.

    Thanks for submitting a great question, and I hope to see more questions coming from you in the future!


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • R.P.Rozema (12/20/2011)


    Yes, sorry for the formatting of the answers. This is my 1st QoD and I couldn't find how to format the answers. So I put them in as best as I could. But the end-result is indeed terrible. Lesson learnt for a next time: put the options in the text and in the answer fields just ask for #1, #2, #3 or #4.

    That is indeed the best option. You can type in the answers in SSMS and take a screenshot. That way we all have the advantage of the color coding 🙂 (and it makes it a bit harder to just run the statements).

    Thanks again for the question, hopefully the first of many to come!

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

  • Hmm, this looks familiar. 😉

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Good question.

  • :). Yes, that's how this question got to be: I did it wrong myself. And so far almost half of the people who tried, had it wrong too. To their avail, the ill-formatted answers don't help them...

    Once more, thanks for your assistance.



    Posting Data Etiquette - Jeff Moden[/url]
    Posting Performance Based Questions - Gail Shaw[/url]
    Hidden RBAR - Jeff Moden[/url]
    Cross Tabs and Pivots - Jeff Moden[/url]
    Catch-all queries - Gail Shaw[/url]


    If you don't have time to do it right, when will you have time to do it over?

  • Tough question. I missed it but learned something today.

    http://brittcluff.blogspot.com/

  • Good question

    Had to come back to this one a couple of times before being sure I was right

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a questionThere are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan I would never join a club that would allow me as a member - Groucho Marx

  • Great question, thanks.

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

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