I've just truncated a very big Transaction log file of a database and I now want to manually run UPDATE STATISTICS on all the tables of the database to improve performance
1) Is it OK to manually run UPDATE STATISTICS if the database itself has AUTO UPDATE/AUTO CREATE STATISTICS on/selected in the Properties/Options of the database? Or does AUTO UPDATE need to be disabled when I manually run UPDATE STATISTICS?
2) Can I run it with users using the database? Is it better to wait till no user is logged in?
3) Do I need to take a backup of the database before updating the statistics? or is it safe for data and not backup is required?