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

Carlo Romagnano

SSC-Insane

Points: 22747

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: 22747 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/

Clustered Index

Cookies on SQLServerCentral