Thanks for your reply. in Simple English, if I update to SP3, everything comes along right i.e. SP1, SP2 AND cumulative ? Next, Is it OK to update SP3 right...

Thank you guys.

Thanks!!! Sorry for the late reply

Thanks you both millions.

Hello experts,

Can you please tell me this Glenn Berry query gives both statistics (index and column) or jut Index stat? I would really appreciate you inputs.

-- When were Statistics...

@gilamonster: My questin was what's the best way to check when statistics were update last time on A DATABASE (all table).

As you said that rebuild index only...

Thank you for replies. last question, what's the BEST query to check statistics on all tables of A DATABASE on production?

Other way around, make B primary and A secondary. But to be noted that there is mirroring configured between A and C and A is principle.

Thank you much for quick and nice reply. Just wanted to ask you again, Data Collection (SSMS) needs to create a Database or table and there are lots of job...

Thank you!!!!

I think you are talking about 2 different things. Window update will show you if updates are ready in window level. But SQL SP2 you have to download and run...

'Ola' scripts are very complicated. Thank you for valuable time sir.

Do you find any 'unusual' in the script? If I want to reorganize and rebuild index > 5000 pages where and how can put this filter in the script? Do...

where can I find that in 'view history' (log) if there was any wait or blockings? Log says:

Message

The job succeed. The job was invoked by schedule ......The last step to...

when u right click on server's name in SSMS. i see different name and when i run select @@servername find different name.