Catalog Views

  • Lokesh Vij

    SSChampion

    Points: 10836

    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 questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • demonfox

    SSCertifiable

    Points: 6289

    Nice to learn new thing. Thanks

    ~ demonfox
    ___________________________________________________________________
    Wondering what I would do next , when I am done with this one :ermm:

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    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.

  • Lokesh Vij

    SSChampion

    Points: 10836

    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 questions

    Link to my Blog Post --> www.SQLPathy.com[/url]

    Follow me @Twitter

  • Mighty

    SSCrazy Eights

    Points: 8814

    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...".

  • call.copse

    SSCoach

    Points: 17206

    @Mighty

    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.

  • Divine Flame

    SSCoach

    Points: 15941

    Thanks for the nice, easy question to start the friday :-)!!


    Sujeet Singh

  • Mighty

    SSCrazy Eights

    Points: 8814

    @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?

  • DugyC

    Hall of Fame

    Points: 3804

    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]

  • (Bob Brown)

    SSCrazy

    Points: 2705

    Good question. Knew three of the choices, had to guess at cb-3 but got it right. Fridays are great!

  • Erav

    SSC-Addicted

    Points: 411

    Nice Question!!:-)

  • Toreador

    SSChampion

    Points: 11257

    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!

  • EL Jerry

    SSCertifiable

    Points: 7053

    Good question to finish the week.

    Happy weekend, everyone!!!

    "El" Jerry.

    "A watt of Ottawa" - Gerardo Galvan

    To better understand your help request, please follow these best practices.[/url]

  • Ken Wymore

    SSCoach

    Points: 16614

    Good question. Thanks!

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply