Clustered Index

Question

Post reply

Clustered Index

demonfox

SSCertifiable

Points: 6289
More actions
March 4, 2013 at 9:10 pm

#271098

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:
March 5, 2013 at 2:55 am

This was removed by the editor as SPAM

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

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

Lokesh Vij SSChampion Points: 10836 More actions · Answer 1

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 More actions · Answer 2

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: 6099 More actions · Answer 3

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: 6099 More actions · Answer 4

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 More actions · Answer 5

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: 19505 More actions · Answer 6

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

Gazareth One Orange Chip Points: 27737 More actions · Answer 7

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

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 8

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: 22737 More actions · Answer 9

Carlo Romagnano

SSC-Insane

Points: 22737

March 5, 2013 at 3:17 am

#1593356

Fantastic!

😀

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 10

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 More actions · Answer 11

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: 22737 More actions · Answer 12

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: 64790 More actions · Answer 13

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/