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)

2007-04-20 (first published: )

1,765 reads

Blogs

Rowcount estimates when there are no Statistics

By

When you don't have statistics, what does SQL use to calculate the estimated number...

Synapse Analytics and .NET for Apache Spark Example 4 - JOINS

By

This is a bit of a longer one, a look at how to do...

Recovering Data from a Backup with SQL Data Compare

By

I had a customer recently ask about how to recover data from a backup...

Read the latest Blogs

Forums

Accessing a RESTORING database for test refresh

By Pete Bishop

I have a requirement whereby testers on ServerA need a copy of the production...

How to get value portion key to every rn from 1 to 3 row on one row?

By ahmed_elbarbary.2010

I need to get value portion key to every 3 row on one row...

Median Processing time, Average Procesisng time for created/closed date

By mnr123

  We have sharepoint as the data source and we have 2 dates created...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers