Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Index types 1 Expand / Collapse
Author
Message
Posted Saturday, August 4, 2012 11:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:20 PM
Points: 5,975, Visits: 8,236
Comments posted to this topic are about the item Index types 1


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1340204
Posted Sunday, August 5, 2012 10:29 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 6:38 PM
Points: 1,371, Visits: 1,560
Nice question, Got to learn something new :)

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1340336
Posted Sunday, August 5, 2012 10:31 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 31, 2014 7:15 PM
Points: 1,129, Visits: 1,163
thanks for the question;learned about xml indexes .


~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one
Post #1340338
Posted Monday, August 6, 2012 12:39 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:28 PM
Points: 13,616, Visits: 10,504
Very nice question Hugo, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1340372
Posted Monday, August 6, 2012 12:43 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 1:11 AM
Points: 1,752, Visits: 476
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.
Post #1340375
Posted Monday, August 6, 2012 12:51 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:10 PM
Points: 21,642, Visits: 15,311
Good question - makes you think a bit.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1340381
Posted Monday, August 6, 2012 1:32 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:47 AM
Points: 1,541, Visits: 8,203
The detailed disclaimer made me laugh - trying to pre-empt any complaints?

BrainDonor
Linkedin
Blog Site
Post #1340391
Posted Monday, August 6, 2012 1:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:20 PM
Points: 5,975, Visits: 8,236
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...

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 MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1340396
Posted Monday, August 6, 2012 1:51 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:43 AM
Points: 1,434, Visits: 721
Well that's got the brain ticking over quite nicely now. Thanks Hugo!
Post #1340402
Posted Monday, August 6, 2012 3:17 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
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!


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1340447
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse