Catalog Views
-
Comments posted to this topic are about the item Catalog Views
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
Nice to learn new thing. Thanks
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: -
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Good question, thank you Lokesh-ji.
Initially I checked the cb-3 box where it stores the poor query details - considering the trace tables from the server-wide catalog tables, but later I unchecked it with doubt (After reading the cb3 several times and the type of information stored in the trace table, this was a lucky guess.)
Finally got it right. 🙂
(This QtoD is a great way of learning the SQL bits, one question at a time, thank you SSC)
ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart. -
Raghavendra Mudugal (8/24/2012)
Good question, thank you Lokesh-ji.Initially I checked the cb-3 box where it stores the poor query details - considering the trace tables from the server-wide catalog tables, but later I unchecked it with doubt (After reading the cb3 several times and the type of information stored in the trace table, this was a lucky guess.)
Finally got it right. 🙂
(This QtoD is a great way of learning the SQL bits, one question at a time, thank you SSC)
Glad to know that you like it very much.
I personally feel that QotD is the best way to learn/refresh our knowledge 🙂
~ Lokesh Vij
Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questionsLink to my Blog Post --> www.SQLPathy.com[/url]
Follow me @Twitter
-
I was doubting on the second option, since it says "inherits" (like in the MSDN article). For me a view that display rows from another view, doesn't inherit rows from that view. We are not talking OO here.
I also think Microsoft made a wrong choice of words in "Catalog views do not contain information about SQL Server Agent...". These views don't contain any data (hence a view). They should have worded it like "Catalog views do not display information about SQL Server Agent...".
-
I think that is a little picky - most will understand that a database row cannot inherit in the sense of programmatically subclassing an object. The rows are inherited in the sense that they are a subset of the rows in the base view with a superset of columns - it's a pretty close analogy IMO.
I thought this was a fairly clear and unambiguous question that made me think a few things through, cheers.
-
Thanks for the nice, easy question to start the friday :-)!!
Sujeet Singh -
@call.copse
I know it is a bit picky, but in the MSDN article they even explained it in a more detailed way with base view, and derived view, etc.
I don't see any added value in that "information". The fact that views can also use views is known by most, if not all, of us, so why expand on that?
-
It's been a good week for questions, and this has been a nice one to finish on.
Thanks for the question, and the point. 😀
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font] -
Good question. Knew three of the choices, had to guess at cb-3 but got it right. Fridays are great!
-
Nice Question!!:-)
-
Guessed wrong, as I'd ruled out "Can inherit rows from other catalog views" on the basis that it is meaningless in this context.
Obviously not!
-
Good question. Thanks!
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply