<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 2 of 3
««
1
2
3
»»
Creating indexes on computed columns
Rate Topic
Display Mode
Topic Options
Author
Message
Imran Ashraf-452633
Imran Ashraf-452633
Posted Thursday, September 30, 2010 2:55 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, May 16, 2013 2:54 AM
Points: 1,103,
Visits: 411
Like the many others I have select the 3 options and not selected Column references can pull data from multiple rows. From what I can tell I was right like the others so give me my 1 point
Post #995788
kaspencer
kaspencer
Posted Thursday, September 30, 2010 3:25 AM
Ten Centuries
Group: General Forum Members
Last Login: 2 days ago @ 10:36 AM
Points: 1,405,
Visits: 253
Yet another error. I won't tolerate any mealy-mouthed excuses, such as those which we have experienced in the past.
Go to the very bottom of the class, and stay there with your dunces cap on, until I permit you to move.
[And give me my point]
Kenneth Spencer.
Post #995795
george sibbald
george sibbald
Posted Thursday, September 30, 2010 3:35 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:17 PM
Points: 5,270,
Visits: 11,212
please see
http://msdn.microsoft.com/en-us/library/ms189292.aspx
, the third answer is incorrect, I am sure Steve will rectify the situation.
this actually follows on from the question two days ago, which is why I answered it.
---------------------------------------------------------------------
Post #995798
William Vach
William Vach
Posted Thursday, September 30, 2010 5:37 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 9:09 AM
Points: 2,114,
Visits: 1,073
The explanation contradicts answer number 3 being true.
Post #995829
rtelgenhoff
rtelgenhoff
Posted Thursday, September 30, 2010 5:58 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, May 03, 2013 6:06 AM
Points: 699,
Visits: 272
Yes,
http://msdn.microsoft.com/en-us/library/ms189292.aspx#BKMK_persisted states that:
"You can create an index on a computed column that is defined with a deterministic, but imprecise, expression if the column is marked PERSISTED in the CREATE TABLE or ALTER TABLE statement."
Post #995840
Toreador
Toreador
Posted Thursday, September 30, 2010 6:29 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356,
Visits: 4,761
"Me too" on the incorrect options stuff.
But in any case, 1 point is a bit mean for a 4-checkbox multiselect question
Post #995864
sjimmo
sjimmo
Posted Thursday, September 30, 2010 6:45 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 7:15 AM
Points: 2,865,
Visits: 2,467
Manie:
Your answers are wrong. You state that you
can
pull data from multiple rows, yet BOL which you state as your reference says
No column reference pulls data from multiple rows. For example, aggregate functions such as SUM or AVG depend on data from multiple rows and would make a computed_column_expression nondeterministic.
Can't have it both ways.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Post #995876
JestersGrind
JestersGrind
Posted Thursday, September 30, 2010 7:12 AM
Hall of Fame
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 1:42 PM
Points: 3,487,
Visits: 1,581
Very disappointing. This is a fairly basic question. A little proofreading could have prevented this from becoming a bad question.
Post #995901
Steve Eckhart
Steve Eckhart
Posted Thursday, September 30, 2010 7:13 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 01, 2013 7:27 AM
Points: 905,
Visits: 8,640
Actually, if you read carefully, an index on a computed column CAN include multiple rows and columns from other tables. As long as
one
of the following four conditions are true, then you can use the computed column in an index. Therefore, only the first answer is necessary and the other three are incorrect answers.
The computed_column_expression must be deterministic. A computed_column_expression is deterministic when one or more of the following is true:
All functions that are referenced by the expression are deterministic and precise. These functions include both user-defined and built-in functions. For more information, see Deterministic and Nondeterministic Functions. Functions might be imprecise if the computed column is PERSISTED. For more information, see Creating Indexes on Persisted Computed Columns later in this topic.
All columns that are referenced in the expression come from the table that contains the computed column.
No column reference pulls data from multiple rows. For example, aggregate functions such as SUM or AVG depend on data from multiple rows and would make a computed_column_expression nondeterministic.
Has no system data access or user data access.
Steve Eckhart
Post #995904
gary.mazzone
gary.mazzone
Posted Thursday, September 30, 2010 7:31 AM
SSCommitted
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:05 PM
Points: 1,541,
Visits: 462
I don't mind getting a question wrong, but only when the answer i give is the wrong one. The third choice is clearly incorrect as true when read in BOL.
Post #995921
« Prev Topic
|
Next Topic »
29 posts, Page 2 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.
