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 […]

(7)

You rated this post out of 5. Change rating

2007-04-20 (first published: )

2,080 reads

Blogs

PowerPoint to HTML with Claude AI

By

I had an idea for an animated view of a sales tool, and started...

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

By

Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...

Monday Monitor Tips: SQL Auditing Preview

By

One of the features we advocates have been advocating for is a better way...

Read the latest Blogs

Forums

Creating JSON I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating JSON I

Expensive CPUs

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Expensive CPUs

Visit the forum

Question of the Day

Creating JSON I

On SQL Server 2025, what happens when I run this code:

SELECT JSON_OBJECTAGG( 'City':'Denver')
GO

See possible answers