Sometimes you just need a quick method to update all statistics of every table. The script below will apply a FULL SCAN , so I wouldn't recommend that you use this as regular maintenancce task . There are other command options for sp_MSforeachtable