Index types 1

Question

Post reply

Index types 1

Hugo Kornelis

SSC Guru

Points: 64790
More actions
August 4, 2012 at 11:52 am

#264776

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/
August 6, 2012 at 3:29 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 29 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, 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

demonfox SSCertifiable Points: 6289 More actions · Answer 2

thanks for the question;learned about xml indexes .

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 3

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

Michael Riemer SSCertifiable Points: 5190 More actions · Answer 4

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

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

BrainDonor SSCoach Points: 19254 More actions · Answer 6

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

Steve Hall
Linkedin
Blog Site

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

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/

SQLPhil SSCarpal Tunnel Points: 4204 More actions · Answer 8

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

DugyC Hall of Fame Points: 3804 More actions · Answer 9

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]

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 10

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

Jack Corbett SSC Guru Points: 184394 More actions · Answer 11

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?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

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

sestell1 SSChampion Points: 10230 More actions · Answer 13

Thanks for the question Hugo!

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