Clustered Index

  • demonfox

    SSCertifiable

    Points: 6289

    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:

  • Lokesh Vij

    SSChampion

    Points: 10836

    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

  • Dineshbabu

    Hall of Fame

    Points: 3220

    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..

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    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 !!!

  • Vinay Kumar

    SSCertifiable

    Points: 6098

    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 !!!

  • DugyC

    Hall of Fame

    Points: 3804

    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]

  • Stuart Davies

    SSCoach

    Points: 18878

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

  • This was removed by the editor as SPAM

  • Gazareth

    One Orange Chip

    Points: 27737

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

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • Carlo Romagnano

    SSC-Insane

    Points: 21987

    Fantastic!

    πŸ˜€

  • Hugo Kornelis

    SSC Guru

    Points: 64685

    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/

  • Dineshbabu

    Hall of Fame

    Points: 3220

    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..

  • Carlo Romagnano

    SSC-Insane

    Points: 21987

    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!

    πŸ˜€

  • Hugo Kornelis

    SSC Guru

    Points: 64685

    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 45 total)

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