Views

  • Comments posted to this topic are about the item Views

    Thanks,
    Shiva N
    Database Consultant

  • Quite the obvious answer πŸ˜€

    Thanks for the question!

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

  • Koen Verbeeck (7/8/2015)


    Quite the obvious answer πŸ˜€

    Thanks for the question!

    It's only obvious if you know the system stored procedures. I didn't even know that existed so I had to check. The other options appear valid until you rule them out. Yes, after that it's the obvious choice, but up to that point I had no idea πŸ™‚


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    β€”Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • EZ.

  • If this gets people more familiar with the system stored procedures, it can only be a good thing. I don't know anyone who knows them all.

  • Ed Wagner (7/8/2015)


    If this gets people more familiar with the system stored procedures, it can only be a good thing. I don't know anyone who knows them all.

    Totally agree.

  • Thanks for that one.

  • Though not provided as an answer, sp_refreshsqlmodule can also refresh views;

    sp_refreshsqlmodule

    Gerald Britton, Pluralsight courses

  • This was removed by the editor as SPAM

  • Koen Verbeeck (7/8/2015)


    Quite the obvious answer πŸ˜€

    Thanks for the question!

    Call it obvious if you want, but when I posted this, only 74% got it right.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • It internally calls the procedure : "sp_refreshsqlmodule_internal"

    Can you tell me this if not resides in master as I can't find it?

    Thanks.

  • Am I the only dummy that doesn't look stuff up before answering? I have been going about this all wrong trying to "test" myself! πŸ˜€ I assumed the obvious answer was too obvious so I guessed wrong.

  • LSAdvantage (7/8/2015)


    Am I the only dummy that doesn't look stuff up before answering? I have been going about this all wrong trying to "test" myself! πŸ˜€ I assumed the obvious answer was too obvious so I guessed wrong.

    [joking]

    You might be the only dummy looking stuff up, but I know some smarter folks like me looks stuff up sometimes. πŸ˜€

    [/joking]



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • Alvin Ramard (7/8/2015)


    LSAdvantage (7/8/2015)


    Am I the only dummy that doesn't look stuff up before answering? I have been going about this all wrong trying to "test" myself! πŸ˜€ I assumed the obvious answer was too obvious so I guessed wrong.

    [joking]

    You might be the only dummy looking stuff up, but I know some smarter folks like me looks stuff up sometimes. πŸ˜€

    [/joking]

    No, he can't be - the real dummies don't bother with QotD. They create meaningless non-question threads in various SQLSCentral forums.

    But maybe some people who don't look things up when they don't know them adopt that policy when writing code as well as when answering questions for fun? :hehe:

    And 75% right answers (it's reached that on this question) is rather a high proportion for QotD πŸ˜‰ Even the 74% you mentioned earlier is unusual.

    Tom

  • Most of the time, the simplest answer is the right one.

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

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