Recompile all programmable objects in a database
This is a example of cursor with recompile objects
Help Query
How to use extended events to catch all error in SQL Server
SQL Server The Extended Events architecture enables users to collect as much or as little data as is necessary to troubleshoot or identify a performance problem. Extended Events is configurable, and it scales very well. Benefits Extended Events Extended Events is a lightweight performance monitoring system that uses minimal performance resources. Extended Events provides two …
How to use extended events to catch all error in SQL Server Read More »
Refresh all views in a database
Updates the metadata for the specified non-schema-bound view. Persistent metadata for a view can become outdated because of changes to the underlying objects upon which the view depends. This scripts help to refresh all view in selected database. Updates all views that have dependencies on a changed object https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-refreshview-transact-sql?view=sql-server-ver15
