July 17, 2012 at 1:39 am
Thank you,I have learnt something.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
July 17, 2012 at 2:35 am
kapfundestanley (7/17/2012)
Thank you,I have learnt something.
Me too - great question to make us thinkg and research.:-D
July 17, 2012 at 3:44 am
Nice question ....
July 17, 2012 at 4:09 am
Very good question. Made think a bit as I knew I had read this some where. Glad I remembered correctly!
July 17, 2012 at 4:14 am
This was removed by the editor as SPAM
July 17, 2012 at 4:57 am
Great question thanks
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
July 17, 2012 at 6:15 am
Thanks for the question. There is also information on this topic in http://msdn.microsoft.com/en-us/library/ms191497(SQL.90).aspx
Edited to correct stupid tag mistake!
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn
July 17, 2012 at 7:15 am
Learned something today from a good question, although it was fairly easy to deduce the correct answer. Given the binary nature of computers the max number of columns without an xml index would likely be 16 or 32. At the very least it would be an even number. Then given that there was a question it strongly indicates that the xml index must take at least one of the available columns away. From the possible answers there was only 1 odd number. I of course chose the "oddball" answer, being the only logical choice and I was correct. My initial thought honestly was that if I got it wrong I didn't really mind too much because I would never make a clustered index cover that many columns. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
July 17, 2012 at 7:35 am
Sean Lange (7/17/2012)
Learned something today from a good question, although it was fairly easy to deduce the correct answer. Given the binary nature of computers the max number of columns without an xml index would likely be 16 or 32. At the very least it would be an even number. Then given that there was a question it strongly indicates that the xml index must take at least one of the available columns away. From the possible answers there was only 1 odd number. I of course chose the "oddball" answer, being the only logical choice and I was correct. My initial thought honestly was that if I got it wrong I didn't really mind too much because I would never make a clustered index cover that many columns. 😀
Yes, I think 15 is plenty.
July 17, 2012 at 9:07 am
tks, good question - cheers
July 17, 2012 at 9:16 am
Good question.
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
July 17, 2012 at 9:40 am
Forced me to do a bit of research. Thanks!
July 17, 2012 at 9:41 am
Nice question, straight forward.
July 17, 2012 at 10:33 am
Good to know, and makes sense. Thanks for the question!
Viewing 15 posts - 1 through 15 (of 22 total)
You must be logged in to reply to this topic. Login to reply