Post-Deployment - Scan for RefreshView/Recompile
A script I can run after deployment to refresh views and force a recompile due to modified DDL.
2016-03-18 (first published: 2016-03-03)
460 reads
Nate Hughes
2013-03-26 (first published: 2013-03-15)
775 reads
2013-02-28 (first published: 2013-02-12)
967 reads
Blogs
Daily Coping 26 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Rowcount estimates when there are no Statistics
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 Ed Elliott
This is a bit of a longer one, a look at how to do...
Forums
Balance is not calculating correctly,when date get change in transection.
Below is data in which two different date are coming,01/19/2021 and 01/18/2021 , Date...
Accessing a RESTORING database for test refresh
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?
I need to get value portion key to every 3 row on one row...
Ask SSC