Views

  • Shiva N

    Hall of Fame

    Points: 3125

    Comments posted to this topic are about the item Views

    Thanks,
    Shiva N
    Database Consultant

  • Koen Verbeeck

    SSC Guru

    Points: 258965

    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

  • Neil Burton

    SSC-Insane

    Points: 22187

    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

  • Hany Helmy

    SSChampion

    Points: 13488

    EZ.

  • Ed Wagner

    SSC Guru

    Points: 286980

    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.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    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.

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for that one.

  • g.britton

    SSChampion

    Points: 13689

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

    sp_refreshsqlmodule

    Gerald Britton, MCSE-DP, MVPToronto PASS Chapter[/url]

  • This was removed by the editor as SPAM

  • Alvin Ramard

    SSC-Forever

    Points: 41190

    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]

  • SQL_Hunt

    SSC-Dedicated

    Points: 33448

    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.

  • SoCal_DBD

    Hall of Fame

    Points: 3098

    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.

  • Alvin Ramard

    SSC-Forever

    Points: 41190

    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]

  • TomThomson

    SSC Guru

    Points: 104773

    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

  • Arno Kwetters

    Hall of Fame

    Points: 3373

    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