<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 VM
»
Rules!
12 posts, Page 1 of 2
1
2
»»
Rules!
Rate Topic
Display Mode
Topic Options
Author
Message
VM-723206
VM-723206
Posted Wednesday, November 18, 2009 10:15 PM
SSChasing Mays
Group: General Forum Members
Last Login: Saturday, April 06, 2013 12:20 AM
Points: 649,
Visits: 263
Comments posted to this topic are about the item
Rules!
Post #821362
SanjayAttray
SanjayAttray
Posted Thursday, November 19, 2009 9:10 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
sysrules in option. Good way to Trick.
Never seen object like this.
SQL DBA.
Post #821707
bitbucket-25253
bitbucket-25253
Posted Thursday, November 19, 2009 12:07 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 7:13 PM
Points: 5,103,
Visits: 20,214
Having recently gotten my brains beat out, my integrity questioned, my intelligence derided and other wise vilified (Refer to the QOD 11/17/2009 forum). I am greatly surprised that the little bitty nitpickers are not raging here in this forum, perhaps it is because they do not intimately know enough about SQL Server or since they got the message they so dearly love to see, that is "You got it right".
But let me point out a technicality: The question asked which of these
views
would you query. The correct answer as given is sysobjects.
Now for the sorry bit of fact the displayed item: sysobjects is a
SYSTEM TABLE
The
VIEW
is sys.sysobjects. Which of course contains essentially the same data as does the system table. To be more specific it is defined as a CATALOG VIEW, but a view nevertheless.
Now this should not be attributed as an effort to denigrate the author of this QOD, knowing how hard it is to compose an "acceptable" QOD.
VM-723206 I congratulate you on your adroit side stepping the nit pickers.
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #821861
Hugo Kornelis
Hugo Kornelis
Posted Thursday, November 19, 2009 1:58 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 3:03 PM
Points: 5,244,
Visits: 7,061
bitbucket-25253 (11/19/2009)
Having recently gotten my brains beat out, my integrity questioned, my intelligence derided and other wise vilified (Refer to the QOD 11/17/2009 forum). I am greatly surprised that the little bitty nitpickers are not raging here in this forum, perhaps it is because they do not intimately know enough about SQL Server or since they got the message they so dearly love to see, that is "You got it right".
But let me point out a technicality: The question asked which of these
views
would you query. The correct answer as given is sysobjects.
Now for the sorry bit of fact the displayed item: sysobjects is a
SYSTEM TABLE
The
VIEW
is sys.sysobjects. Which of course contains essentially the same data as does the system table. To be more specific it is defined as a CATALOG VIEW, but a view nevertheless.
If you are going to pick nits, make sure you get your facts right.
In SQL Server 2000 and older versions, sysobjects was indeed a system table. But as of SQL Server 2005, system tables are no longer exposed. They have been replaced by system views, of which sys.objects (that is, the view named objects in the schema named sys) is an example.
To preserve compatibility with older versions, a second set of views, the so-called compatibility views, were introduced. One of those views is sys.sysobjects. And to preserve full compatibility, SQL Server will find this view even if you omit the schema name and shorten it to just sysobjects.
So, unless you assumed the question to be about SQL Server 2000 or before, you picked the wrong nit. For in all current versions of SQL Server, sysobjects is indeed a view, not a table.
The true nitpicker though, would have complained about something else - and that is that the real true answer is not included. Books Online includes a note with all compatibility views that these will be removed in a future version of SQL Server, and that the current SQL Server system views should be used instead. So the only really correct answer would have been to query the sys.objects view.
Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
Post #821944
SQLRNNR
SQLRNNR
Posted Thursday, November 19, 2009 4:28 PM
SSCoach
Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754,
Visits: 12,337
While these are valid arguments about nit-picking of questions, one vital piece of information was overlooked. This question was only worth 1 point.
Bitbucket, your question was worth more points. Had it only been 1 point, there would have been far less picking.
Jason
AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #822011
Bhavesh_Patel
Bhavesh_Patel
Posted Thursday, November 19, 2009 10:00 PM
SSChasing Mays
Group: General Forum Members
Last Login: Friday, January 11, 2013 12:41 PM
Points: 621,
Visits: 297
Hey this was easy one. Hope for more such easy Q's in future!
Bhavesh Patel
http://bhaveshgpatel.wordpress.com/
Post #822092
Scott Coleman
Scott Coleman
Posted Friday, November 20, 2009 7:46 AM
SSCrazy
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:39 PM
Points: 2,818,
Visits: 1,038
You could quibble that the complete rule is not stored in sysobjects, since the rule definition is in syscomments. But sysobjects is the best answer of the choices given.
Post #822408
BudaCli
BudaCli
Posted Wednesday, December 02, 2009 2:33 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, March 27, 2013 9:02 AM
Points: 1,046,
Visits: 573
Beaten but a leeson learned should never be learned again.
What you don't know won't hurt you but what you know will make you plan to know better
Post #827272
RBarryYoung
RBarryYoung
Posted Saturday, December 05, 2009 9:48 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Saturday, May 04, 2013 11:13 AM
Points: 9,855,
Visits: 9,374
Yes, could we
please
stop asking QotD's that only have correct answers for SQL Server 2000?
-- RBarryYoung
,
(302)375-0451
blog:
MovingSQL.com
, Twitter:
@RBarryYoung
Proactive
Performance Solutions, Inc.
"Performance is our middle name."
Post #829498
David Burrows
David Burrows
Posted Wednesday, January 06, 2010 7:14 AM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 11:13 AM
Points: 6,351,
Visits: 5,369
RBarryYoung (12/5/2009)
Yes, could we
please
stop asking QotD's that only have correct answers for SQL Server 2000?
Now that is nit-picking
Far away is close at hand in the images of elsewhere.
Anon.
Post #842773
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
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.
