Updating database statistics

1

In Windows, from the Start menu, select All Programs > Microsoft SQL Server > Query Analyzer.

2

Connect to the database.

3

Enter the following script:

DECLARE @table_name varchar(1000),@sql nvarchar(4000)

declare c1 cursor for

SELECT name
FROM sysobjects
WHERE xtype = 'U'
open c1 fetch next from c1 into @table_name
while @@Fetch_Status = 0

begin

Select @sql = 'UPDATE STATISTICS ['+ @table_name +'] WITH FULLSCAN'
exec sp_executesql @sql
fetch next from c1 into @table_name

end
close c1
deallocate c1
GO
declare @cmd nvarchar(500)

declare cur_sp cursor fast_forward read_only local for

select 'exec sp_recompile ['+object_name(o.id)+']'
from sysobjects o
where o.xtype = 'U'

open cur_sp fetch next from cur_sp into @cmd
while @@Fetch_Status = 0
begin

exec sp_executesql @cmd fetch next from cur_sp into @cmd

end
close cur_sp
deallocate cur_sp
go

4

Execute the query.