SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Rules!


Rules!

Author
Message
VM-723206
VM-723206
Right there with Babe
Right there with Babe (776 reputation)Right there with Babe (776 reputation)Right there with Babe (776 reputation)Right there with Babe (776 reputation)Right there with Babe (776 reputation)Right there with Babe (776 reputation)Right there with Babe (776 reputation)Right there with Babe (776 reputation)

Group: General Forum Members
Points: 776 Visits: 267
Comments posted to this topic are about the item Rules!
SanjayAttray
SanjayAttray
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4433 Visits: 1619
sysrules in option. Good way to Trick.

Never seen object like this.

SQL DBA.
bitbucket-25253
bitbucket-25253
SSCertifiable
SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)SSCertifiable (7.9K reputation)

Group: General Forum Members
Points: 7939 Visits: 25280
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
Hugo Kornelis
Hugo Kornelis
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11152 Visits: 12004
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. :-P

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
SQLRNNR
SQLRNNR
SSC-Dedicated
SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)SSC-Dedicated (32K reputation)

Group: General Forum Members
Points: 32952 Visits: 18560
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, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw

Bhavesh_Patel
Bhavesh_Patel
Say Hey Kid
Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)Say Hey Kid (683 reputation)

Group: General Forum Members
Points: 683 Visits: 297
Hey this was easy one. Hope for more such easy Q's in future! :-D



Bhavesh Patel

http://bhaveshgpatel.wordpress.com/
Scott Coleman
Scott Coleman
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3850 Visits: 1465
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.



BudaCli
BudaCli
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1268 Visits: 598
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
RBarryYoung
RBarryYoung
SSCoach
SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)SSCoach (15K reputation)

Group: General Forum Members
Points: 15106 Visits: 9518
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."
David Burrows
David Burrows
SSCrazy Eights
SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)SSCrazy Eights (9.7K reputation)

Group: General Forum Members
Points: 9729 Visits: 9764
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 :-P


Far away is close at hand in the images of elsewhere.

Anon.


Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search