March 16, 2014 at 2:13 am
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
March 19, 2014 at 9:24 am
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.
March 27, 2014 at 7:33 pm
The database leve and sp_udatestats is the correct answer. Please read carefully your own question.
April 9, 2014 at 2:36 am
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