Thanks for your reply, my issue is that I am having major performance issues from time to time the only thing that seems to fix it is running these commands,...

can you please specify why running these commands would not be good to run in a production environment?

that's is what i thought, then do you know why it works from my local server and not this specific server, i am using the same login. Like i...

Thank you for your response after having a couple of meetings we agrreed the report should only have 50 essential colums. These data is not summarized, What other consiserations...

Thank you Frank, it worked perfectly. 😀

yes i do.

Unfortunately we are still using excel 2003

perfect! thanks a bunch

I have all the users and logins can you please tell me how to do the sp_change_users_login sp please i am having some issues conecting from the application side.

thank you!! i saw that i could do the same in the OPTIONS page when doing the restore, what is the difference between the logical and the file name. ...

thanks for your reply, for the dbo.IndexOptimize sp for some reason is skipping one of my databases, it is online.

thanks!then is not necessary create a separate job for a update statistics with full scan after the rebuild since it is already doing so.

Questions: is using the rebuild...

To the ones that were rebuilt does it update the statistics with FULL SCAN?

hi Ola question about your stored procedure, for some reason is skipping one of my user databases which is in simple recovery model, is your sp only made for DBs...

it worked perfectly thank you so much!