Update statistics in all databases

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

delamater SSC Rookie Points: 43 More actions · Answer 1

SSC Rookie

Points: 43

April 16, 2010 at 8:50 am

Why not use sp_updatestats?

adeilsonrbrito SSC Enthusiast Points: 113 More actions · Answer 2

Because sp_updatestats just update statistics in all tables in the current database.

delamater SSC Rookie Points: 43 More actions · Answer 3

Ha! I must not have had my first cup of coffee before making that post. Good call.

adeilsonrbrito SSC Enthusiast Points: 113 More actions · Answer 4

SSC Enthusiast

Points: 113

April 17, 2010 at 6:01 am

No problem. Thanks for your message.

AndrewB-A Old Hand Points: 316 More actions · Answer 5

Hi,

I have some databases with spaces in the names and so I added some square brackets;

USE master

go

exec sp_MSforeachdb

' IF (''?'' NOT IN (''master'',''tempdb'',''model'',''msdb'',''ReportServerTempDB''))

BEGIN PRINT ''Atualizando estatísticas de '' + ''?''

use [?] exec sp_updatestats END';

Thanks for the useful snippet!

adeilsonrbrito SSC Enthusiast Points: 113 More actions · Answer 6

SSC Enthusiast

Points: 113

April 18, 2010 at 7:33 pm

Very good. In fact, this is necessary. Thanks.

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 7

SSC Guru

Points: 76202

May 19, 2016 at 7:11 am

Thanks for the script.