<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 Manie Verster
»
Creating indexes on computed columns
29 posts, Page 1 of 3
1
2
3
»
»»
Creating indexes on computed columns
Rate Topic
Display Mode
Topic Options
Author
Message
Manie Verster
Manie Verster
Posted Wednesday, September 29, 2010 9:49 PM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 3:00 AM
Points: 1,151,
Visits: 879
Comments posted to this topic are about the item
Creating indexes on computed columns
Manie Verster
Developer
Johannesburg
South Africa
Life is about choices.... I choose to be happy today
Post #995722
UMG Developer
UMG Developer
Posted Wednesday, September 29, 2010 9:52 PM
SSCrazy
Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163,
Visits: 2,148
I think you need to check the answer key for this question. It lists "Column references can pull data from multiple rows." as one of the options you have to pick, but then in your explanation you say "No column reference pulls data from multiple rows."
And the BOL article you link to says 'No column reference pulls data from multiple rows.", so it seems that "Column references can pull data from multiple rows." is not a correct choice. Either that or you meant for the
can
to be
can't
.
Post #995723
Oleg Netchaev
Oleg Netchaev
Posted Wednesday, September 29, 2010 10:01 PM
SSCommitted
Group: General Forum Members
Last Login: 2 days ago @ 10:53 AM
Points: 1,662,
Visits: 1,709
Wow, this is so ridiculous. The referenced BOL page clearly states:
No column reference pulls data from multiple rows
The answer, however includes the opposite and still claims it as a correct option. As a matter of fact even the wording of all listed options matches the BOL word by word except it does not include the word
NO
for the multiple rows option.
Oleg
Post #995726
Kingston Dhasian
Kingston Dhasian
Posted Wednesday, September 29, 2010 11:00 PM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:18 AM
Points: 2,230,
Visits: 4,197
UMG Developer (9/29/2010)
I think you need to check the answer key for this question. It lists "Column references can pull data from multiple rows." as one of the options you have to pick, but then in your explanation you say "No column reference pulls data from multiple rows."
And the BOL article you link to says 'No column reference pulls data from multiple rows.", so it seems that "Column references can pull data from multiple rows." is not a correct choice. Either that or you meant for the
can
to be
can't
.
I agree. The answer key for the question is wrong. The explanation is correct as per BOL. I think the editors will rectify this soon.
Kingston Dhasian
How to post data/code on a forum to get the best help - Jeff Moden
http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #995740
honza.mf
honza.mf
Posted Thursday, September 30, 2010 1:04 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 4:05 AM
Points: 1,103,
Visits: 1,199
Just another 0=1
See, understand, learn, try, use efficient
© Dr.Plch
Post #995761
Carlo Romagnano
Carlo Romagnano
Posted Thursday, September 30, 2010 1:09 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 1:51 AM
Points: 1,972,
Visits: 1,821
Here the script that states "No column reference pulls data from multiple rows"
create function aaaa() returns int
as
begin
return (select SUM(a) from aza )
end
GO
create table aza(a int,b as dbo.aaaa())
create index idx_aza on aza(b) -- raise error: function is NON-DETERMINISTIC
Post #995762
Hardy21
Hardy21
Posted Thursday, September 30, 2010 1:23 AM
SSC Eights!
Group: General Forum Members
Last Login: Yesterday @ 7:11 AM
Points: 877,
Visits: 1,159
Though I am right, I lose point
Thanks
Post #995771
Christian Buettner-167247
Christian Buettner-167247
Posted Thursday, September 30, 2010 1:43 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 2,526,
Visits: 3,620
The first answer (All functions that are referenced by the expression are deterministic and precise.) is incorrect as well. As long as the column is persisted, imprecise functions can be used.
Best Regards,
Chris Büttner
Post #995774
michael.kaufmann
michael.kaufmann
Posted Thursday, September 30, 2010 2:22 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, February 06, 2013 11:51 PM
Points: 1,263,
Visits: 1,079
UMG Developer (9/29/2010)
I think you need to check the answer key for this question. It lists "Column references can pull data from multiple rows." as one of the options you have to pick, but then in your explanation you say "No column reference pulls data from multiple rows."
And the BOL article you link to says 'No column reference pulls data from multiple rows.", so it seems that "Column references can pull data from multiple rows." is not a correct choice. Either that or you meant for the
can
to be
can't
.
Fully agree with UMG Developer.
And I'd also agree with Chris Büttner--but in order to gain a point, just stick with the wording in BOL and disregard anything else, as computed columns need to be
persisted
in order to be used in an index (and the question was only about 'computed columns' but not about 'persisted computed columns').
Regards,
Michael
Post #995779
paul.knibbs
paul.knibbs
Posted Thursday, September 30, 2010 2:46 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 6:28 AM
Points: 1,258,
Visits: 4,259
I carefully left that third option unchecked because I thought it was the author attempting a bit of a trick by having just that one worded differently from BOL, too!
Post #995783
« Prev Topic
|
Next Topic »
29 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.
