<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Hugo Kornelis
»
Index types 2
25 posts, Page 1 of 3
1
2
3
»
»»
Index types 2
Rate Topic
Display Mode
Topic Options
Author
Message
Hugo Kornelis
Hugo Kornelis
Posted Wednesday, August 29, 2012 11:22 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 5,296,
Visits: 7,236
Comments posted to this topic are about the item
Index types 2
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1352010
Koen Verbeeck
Koen Verbeeck
Posted Thursday, August 30, 2012 12:16 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 9,410,
Visits: 6,495
Great question Hugo, made me do some research
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 #1352020
BrainDonor
BrainDonor
Posted Thursday, August 30, 2012 1:20 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, June 14, 2013 8:33 AM
Points: 1,402,
Visits: 6,950
Me too - quite a bit of hunting to get the right answers. Thanks for the interesting question.
BrainDonor
Linkedin
Post #1352034
Hugo Kornelis
Hugo Kornelis
Posted Thursday, August 30, 2012 1:22 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 5,296,
Visits: 7,236
Thanks, Koen! (EDIT: And Braindonor, who added a reply while I was typing)
I submitted this question quite a long time ago - and I found that I had to spend time to research some of the options again.
BTW, maybe it's a bit early to say anything about the percentages, but at this point I am mainly surprised at:
* 28% wrong answers on the "bitmap on computed" option - I expected this to be lower
* 17% wrong answers on the "nonclustered on a view" option - here, I expected a higher failure rate
The other percentages are (so far) about on par with my expectation.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1352035
Gazareth
Gazareth
Posted Thursday, August 30, 2012 2:57 AM
UDP Broadcaster
Group: General Forum Members
Last Login: Monday, June 10, 2013 4:11 AM
Points: 1,474,
Visits: 2,344
Nice question Hugo, thanks.
Got 3 of the 4 - knew bitmap indexes were available on other DB software, thought it might have been introduced with 2012.
Thought 260 columns for columnstore indexes was a slightly random number so didn't go for that
Post #1352059
Hugo Kornelis
Hugo Kornelis
Posted Thursday, August 30, 2012 3:17 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 5,296,
Visits: 7,236
Gazareth (8/30/2012)
Nice question Hugo, thanks.
Got 3 of the 4 - knew bitmap indexes were available on other DB software, thought it might have been introduced with 2012.
Thought 260 columns for columnstore indexes was a slightly random number so didn't go for that
Thanks, Gazareth!
The 260 number is deliberately chosen to exceed 256, 2
8
or the number of values in a tinyint. This vlaue is a common boundary value in software. (For example, before SQL Server 2008, nonclustered indexes on a table were identified by a tinyint column with two reserved values, leaving room for 254 other values; the actual maximum number was 250 - I think they simply rounded down to a pretty number). So I picked the number 260 to distinguish those who believe in a maximum of 256 columns per columnstore index from those who believe in a larger or no maximum.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1352067
DugyC
DugyC
Posted Thursday, August 30, 2012 3:54 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 1,182,
Visits: 745
Thanks for the great question Hugo, got the brain matter working. Had to answer by process of elimination and learned something new on the way. Excellent.
Cheers
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1352080
Hugo Kornelis
Hugo Kornelis
Posted Thursday, August 30, 2012 4:03 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 6:13 AM
Points: 5,296,
Visits: 7,236
DugyC (8/30/2012)
Had to answer by process of elimination
Thanks, Dugy!
Frankly, I am a bit disappointed that the site moderators included the number of correct answers. I had included a note that there are multiple correct answers without specifying how many, to make it a true test of knowledge - but apprently, including the number of correct answers for questions with more than one answer is now standard practice, applied to all those questions.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1352083
Divine Flame
Divine Flame
Posted Thursday, August 30, 2012 4:17 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 7:29 AM
Points: 1,084,
Visits: 1,954
Very good question! Thanks.
- Divine Flame
Post #1352085
Thomas Abraham
Thomas Abraham
Posted Thursday, August 30, 2012 5:53 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 5:11 AM
Points: 1,168,
Visits: 1,470
Thanks for the question Hugo. I should have stretched out before running that hard early in the morning. I think I strained something!
I certainly learned something.
Please don't go. The drones need you. They look up to you.
Post #1352127
« Prev Topic
|
Next Topic »
25 posts, Page 1 of 3
1
2
3
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
