Technical Article

Refreshing Views and Recompiling Stored Procs

When a table is modified by changing the order of fields or changing field type or adjusting field sizes etc, some of the dependent views (or views on views on views :)) may become invalid as they store some metadata in order to run more efficiently. These views would need to be refreshed with new […]

4.86 (7)

You rated this post out of 5. Change rating

2007-04-20 (first published: )

2,064 reads

Blogs

Monday Monitor Tips: Searching Permission Changes

By

During a demo of Redgate Monitor Enterprise to a customer, they asked about how...

SQL Bits 2025 Wrap

By

SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...

Get Certified in Microsoft Azure Data Fundamentals (DP-900) FAST with NO Experience Needed

By

As data becomes the backbone of modern business, understanding how to manage and analyze...

Read the latest Blogs

Forums

SQL Server 2008 to SQL Server 2022

By Skybvi

Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

The Hidden Cost of MAXDOP: CPU Spikes, Query Slowdowns, and What We Learned

By Chandan Shukla

Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...

Visit the forum

Question of the Day

Using Heaps

When does Microsoft recommend using a heap as a table structure (no clustered index)?

See possible answers