Technical Article

SQL Server All View Refresh

,

run the script I prepared to update all the views in the database.

Yusuf KAHVECI

yusufkahveci@sqlturkiye.com

www.sqlturkiye.com

Thanks

USE <Database_Name>
GO
DECLARE @sqlTrexec NVARCHAR(MAX)=''
SELECT @sqlTrexec = @sqlTrexec + 'EXEC sp_refreshview ''' + name + '''; 
'
FROM sys.objects AS syso
WHERE syso.type='V'
EXEC (@sqlTrexec)
--SELECT @sqlTrexec

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.5 (4)

You rated this post out of 5. Change rating

Share

Join the discussion and add your comment

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

2.5 (4)

You rated this post out of 5. Change rating

Related content

External Article

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.

2018-06-26

2,974 reads

Cookies on SQLServerCentral

This website stores cookies on your computer.

These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.

To find out more about the cookies we use, see our Privacy Policy