I am trying to create a Maintenance Plan in SQL 2005; I need to do the following:
Transactional log every 2 hours
Differential every 4 hours
Full every day
Which one should I do first Rebuild index or update statistics and how frequently should I performs those steps?
Thank you in advance.