We've been having a number of issues with our indexes lately which our DBA team has attributed to statistics not having been run recently. This has made me wonder - how can I check if statistics have been recently updated via SQL Management Studio?
I apologize if this question isn't explaining this very well - I've only been introduced to statistics until now and prior to this would look to indexes whenever I've had performance related issues.
I'm using the following but receiving a syntax error:
use *databasename* exec sp_autostats *schema.tablename*
The error I'm receiving is:
Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '.'.
Why is this?