VIEW - 9

  • Ron McCullough

    SSC Guru

    Points: 63877

    Comments posted to this topic are about the item VIEW - 9

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • SQLRNNR

    SSC Guru

    Points: 281210

    Nice Question Ron.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • TomThomson

    SSC Guru

    Points: 104772

    Fun question.

    I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view is not indexed and can't have statistics.

    Tom

  • Lokesh Vij

    SSChampion

    Points: 10836

    Ah..Good question to begin with our Monday morning 🙂

    ~ 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

  • Lokesh Vij

    SSChampion

    Points: 10836

    L' Eomot Inversé (10/14/2012)


    Fun question.

    I wonder how many people will fail to notice that although you've got everything ready to create the index you haven't actually done so, so the view is not indexed and can't have statistics.

    Correct answers: 79% (33)

    Incorrect answers: 21% (9)

    9/42 already failed to noticed this..

    ~ 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 question ..

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

  • DugyC

    Hall of Fame

    Points: 3804

    I'm not very offay with Views, not used them much at all.

    However after the last question like this I knew it needed that clustered index so got the answer right this time round.

    Great questions, cheers.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out to research that, and I thought this was a great question.

    Than, I (luckily) doublechecked the question - and found that it is actually a question that tests my ability to read carefully, and to not fall victim to suggested information.

    The way the question is worded (with the starting words: "I set the options to support indexed views" (emmphasis mine) suggests that the view is indexed. It is very easy to overlook the fact that no index is created, hence it is a normal, unindexed view.

    Ron has already submitted a lot of questions, and I have never seen him intentionally try to trick people, so I am sure that it was not his intention to make this a trick question either.


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Koen Verbeeck

    SSC Guru

    Points: 258940

    Hugo Kornelis (10/15/2012)


    At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out to research that, and I thought this was a great question.

    Than, I (luckily) doublechecked the question - and found that it is actually a question that tests my ability to read carefully, and to not fall victim to suggested information.

    The way the question is worded (with the starting words: "I set the options to support indexed views" (emmphasis mine) suggests that the view is indexed. It is very easy to overlook the fact that no index is created, hence it is a normal, unindexed view.

    Ron has already submitted a lot of questions, and I have never seen him intentionally try to trick people, so I am sure that it was not his intention to make this a trick question either.

    +1

    I did not read carefully 😀

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

  • call.copse

    SSCoach

    Points: 16861

    I thought this one was pretty clear and unambiguous, no trickery just the knowledge / research required to amswer it.

  • Richard Warr

    SSCertifiable

    Points: 6955

    Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    Richard Warr (10/15/2012)


    Would there also be a difference between dbo.c_view and dbo.C_view if you had case sensitive collation set?

    Yes, if your database uses case sensitive collation, "c_view" is different from "C_view". (And "dbo" is also different frmo "Dbo").


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • This was removed by the editor as SPAM

  • (Bob Brown)

    SSCrazy

    Points: 2705

    Great Monday morning question. Thanks.

  • Erav

    SSC-Addicted

    Points: 411

    A very good question.:-)

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

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