<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 Tom Thomson
»
ANSI Padding
33 posts, Page 2 of 4
««
1
2
3
4
»
»»
ANSI Padding
Rate Topic
Display Mode
Topic Options
Author
Message
paul.knibbs
paul.knibbs
Posted Tuesday, January 11, 2011 2:21 AM
Ten Centuries
Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 1,257,
Visits: 4,257
I got it right apart from the last option--the reference I was looking at didn't mention anything about TOP performance being affected by this. Not greatly saddened because I don't think it likely I'll ever run into this anyway, but more information is always handy to have!
Post #1045748
Christian Buettner-167247
Christian Buettner-167247
Posted Tuesday, January 11, 2011 2:31 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 12:37 AM
Points: 2,526,
Visits: 3,619
Toreador (1/11/2011)
As for the option about performance relative to SQL2000 - that's an 11-year-old unsupported version[...]
SQL Server 2000 is not unsupported. Only the mainstream support has ended.
http://blogs.msdn.com/b/sqlreleaseservices/archive/2008/02/15/end-of-mainstream-support-for-sql-server-2005-sp1-and-sql-server-2000-sp4.aspx
Best Regards,
Chris Büttner
Post #1045751
paul s-306273
paul s-306273
Posted Tuesday, January 11, 2011 3:15 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 4:24 AM
Points: 1,158,
Visits: 642
Good question - I see only 8% have got the correct answer at the moment.
Post #1045763
Toreador
Toreador
Posted Tuesday, January 11, 2011 3:22 AM
Ten Centuries
Group: General Forum Members
Last Login: Friday, May 17, 2013 9:52 AM
Points: 1,356,
Visits: 4,761
Christian Buettner-167247 (1/11/2011)
SQL Server 2000 is not unsupported. Only the mainstream support has ended.
So it's supported, but only if we pay for it.
In my book, that means it's unsupported
Post #1045765
Hugo Kornelis
Hugo Kornelis
Posted Tuesday, January 11, 2011 3:50 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 2:13 PM
Points: 5,237,
Visits: 7,044
Usually, when I come to the forum while thinking that the question is not 100% acccurate, I encounter lots of similar remakrs already. Today, nobody has yet raised the point I want to make - so I'm beginning to doubt myself. Please tell me if I misread Books Online...
On the page referenced from the question's explanation, it says:
For more information about required SET option settings with indexed views and indexes on computed columns, see "Considerations When You Use the SET Statements" in
SET (Transact-SQL)
.
Following that page and scrolling down to the last paragraph, I read:
If any one of these options is not set to the required values, (...) SQL Server will process SELECT statements on these tables or indexed views as if the indexes on computed columns or on the views do not exist.
My interpretation of this text is that indexes on computed columns will not be used when ANSI_PADDING and various other SET options are not set to the required value. But the explanation in the question says the exact reverse: "(...) but existing indexes
can
be used" (emphasis is mine).
Did I misinterpret the documentation? Or is Tom incorrect? (Christian's test code suggests the latter).
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #1045774
L' Eomot Inversé
L' Eomot Inversé
Posted Tuesday, January 11, 2011 5:31 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 3:07 PM
Points: 7,096,
Visits: 7,156
Hugo Kornelis (1/11/2011)
Did I misinterpret the documentation? Or is Tom incorrect? (Christian's test code suggests the latter).
I think you are right - I got it wrong. Mea maxima culpa - I should have checked thoroughly instead of relying on (evidently faulty) memory.
Perhaps Steve can correct the answer and the explanation before more people are bitten by my error.
Tom
Que conclure à la fin de tous mes longs propos? C'est que les préjugés sont la raison des sots. (Voltaire, 1756)
Post #1045821
mtassin
mtassin
Posted Tuesday, January 11, 2011 7:50 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 1:30 AM
Points: 3,226,
Visits: 64,247
DugyC (1/11/2011)
God damn it!! I would have got this one right had I read the MSDN linked page properly, it was my reference from google.
I assumed VARCHAR & NVARCHAR would be treated the same, instead of reading further down and seeing that NVARCHAR is unaffected.
Lost point, but through my own stupidity... that is frustrating!
/agree
did the same thing...
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1045908
SanDroid
SanDroid
Posted Tuesday, January 11, 2011 8:21 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232,
Visits: 1,046
Tom.Thomson (1/11/2011)
Hugo Kornelis (1/11/2011)
Did I misinterpret the documentation? Or is Tom incorrect? (Christian's test code suggests the latter).
I think you are right - I got it wrong. Mea maxima culpa - I should have checked thoroughly instead of relying on (evidently faulty) memory.
Perhaps Steve can correct the answer and the explanation before more people are bitten by my error.
That would be great considering the only ones that have got the question right or those that understand the SET command wrong.
I noticed that the last question I submitted left the question as it was after the original submission. It was changed after that to be something differant, but the original with mistakes is what was posted as QOTD. Maybe Steve can fix that as well so we stop having so many of these kind of QOTD's.
Post #1045929
Richard Sisk
Richard Sisk
Posted Tuesday, January 11, 2011 8:48 AM
SSCommitted
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:19 AM
Points: 1,877,
Visits: 205
Would have got it right except I was thrown by the apparent conflict that the question was for SQL Server 2008 but the last option clearly asks about SQL Server 2000. Why would I select a SQL2000 option if the question is about SQL2008?
Other than that, great question. I learned some new stuff today.
Post #1045950
Adam Sottosanti
Adam Sottosanti
Posted Tuesday, January 11, 2011 9:19 AM
SSC-Enthusiastic
Group: General Forum Members
Last Login: Yesterday @ 3:32 PM
Points: 128,
Visits: 314
Tough question, thanks for posting. This one should have been worth more than one point.
Adam Sottosanti
Post #1045971
« Prev Topic
|
Next Topic »
33 posts, Page 2 of 4
««
1
2
3
4
»
»»
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.
