Clustered Index

  • Comments posted to this topic are about the item Clustered Index

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

  • Nice question demonfox... Overlooked and got the question wrong. Lesson learnt! πŸ™‚

    ~ 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

  • Really interesting one.

    Thanks for making me to understand that disabling a clustured index will block DML operations on underlying table.

    --
    Dineshbabu
    Desire to learn new things..

  • Very good question. For get a correct answer and point, you need to look as question very carefully.

    keep it up !!! πŸ™‚

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Dineshbabu (3/4/2013)


    Really interesting one.

    Thanks for making me to understand that disabling a clustured index will block DML operations on underlying table.

    me too. πŸ™‚

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!

  • Danny Ocean (3/5/2013)


    Very good question. For get a correct answer and point, you need to look as question very carefully.

    keep it up !!! πŸ™‚

    +1

    Great question thanks

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

  • Very good question Demonfox - thanks.

    Took four re-reads and two cups of coffee before getting my point this morning

    -------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
    There 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

  • This was removed by the editor as SPAM

  • Nice question, thanks. Missed that the rebuild would re-enable the index, duh!

  • Nice question, thanks. I only had to check 3 statements to get my answer: 1, 5 and 6 πŸ™‚

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

  • Fantastic!

    πŸ˜€

  • Good question, and good explanation. Well done!


    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/

  • Hugo Kornelis (3/5/2013)


    Good question, and good explanation. Well done!

    First time I'm seeing Hugo's post without any information.

    --
    Dineshbabu
    Desire to learn new things..

  • Dineshbabu (3/5/2013)


    Hugo Kornelis (3/5/2013)


    Good question, and good explanation. Well done!

    First time I'm seeing Hugo's post without any information.

    We are waiting for "L'Γ¨mot est inversΓ©e", Tom for friends!

    πŸ˜€

  • Dineshbabu (3/5/2013)


    Hugo Kornelis (3/5/2013)


    Good question, and good explanation. Well done!

    First time I'm seeing Hugo's post without any information.

    Normally, I either post with additional information, or do not post at all. But in this case, even though I didn't see anything I could add to the explanation, I felt a compliment was in order.


    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/

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

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