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:36 PM
Points: 6,133, Visits: 8,398
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, December 2, 2014 9:20 AM
Points: 1,372, Visits: 1,567
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, December 11, 2014 9:19 PM
Points: 1,129, Visits: 1,164
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: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
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: Monday, December 15, 2014 8:05 AM
Points: 1,877, Visits: 518
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 3:20 PM
Points: 18,064, Visits: 16,099
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
Post #1340381
Posted Monday, August 6, 2012 1:32 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: 2 days ago @ 5:55 AM
Points: 1,483, Visits: 8,545
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:36 PM
Points: 6,133, Visits: 8,398
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: Tuesday, November 18, 2014 4:14 AM
Points: 1,443, Visits: 728
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