Updating Statistics

  • TomThomson (3/14/2014)


    Nice question, I had forgotten that sp_updatestats existed so I got it wrong. Maybe now I'll remember 😉

    How did I miss that?! the database level.:hehe:

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • Oh dear. Would have gone for the correct answer if I hadn't paused and asked myself what this question really wanted. My interpretation was that you can't update statistics on multiple tables using just one statement which left only the database level.

    I'll avoid any questions in the future that make me wonder what they are asking for.

  • The database leve and sp_udatestats is the correct answer. Please read carefully your own question.

  • Easy one for me.thanks

    “When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris

Viewing 4 posts - 16 through 18 (of 18 total)

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