Index types 1

  • Comments posted to this topic are about the item Index types 1


    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/

  • Nice question, Got to learn something new 🙂

    ~ 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

  • thanks for the question;learned about xml indexes .

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • Very nice question Hugo, thanks.

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

  • Great Question Hugo - thanks.

    Had to do a lot of reading to check what I already seemed to know, but taught me more about what I didn't know. 🙂

  • Good question - makes you think a bit.

    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

  • The detailed disclaimer made me laugh - trying to pre-empt any complaints?

  • BrainDonor (8/6/2012)


    The detailed disclaimer made me laugh - trying to pre-empt any complaints?

    Let's just say that this is not my first QotD submission... :w00t:

    By the way, the "please select 3" notice was added by the editor, not me. I only added the "multiple correct answers", but deliberately omitted the number of correct answers, and I am actually a bit disappointed that this number was added. 🙁


    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/

  • Well that's got the brain ticking over quite nicely now. Thanks Hugo!

  • Oof! fluked this one.

    Knew the first 2 were right, and that columnstore was non-clustered. Guessed it was probably an XML index and decided "for value" would be more useful.

    Phew! 🙂

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • This was removed by the editor as SPAM

  • Too much for me to handle on Monday morning. Nice question.

  • I over thought this one, and knew I was doing it, but still did it anyway. My thinking was that, while you do not have to define a clustered index as unique, SQL Server does add a uniqufier, thus I eliminated non-unique clustered index. See what I mean about over-thinking?

  • BrainDonor (8/6/2012)


    The detailed disclaimer made me laugh - trying to pre-empt any complaints?

    I don't blame him. I've decided I'll have to retain an attorney before I do another QotD. 🙂

    Thanks, Hugo, for the question. But it was a bit too much for me for a Monday. I don't use non-unique clustered indexes, so I got lost looking for the right answer.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Thanks for the question Hugo!

    I had to research the XML indexes again... not something I use.

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

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