Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Wilfred van Dijk,
Split the ratio in read/write ratio, several improvements
The main part is now a CTE. This reduces the subtreecost a lot. I was triggered by the Question of the Day ("can a CTE be used in a view")
Create this view in the specified database and select from this view
Execution Plan -- Clustered Index Update
HELP= Rebuild index & Update STATISTICS
A script to get the user table query ratio and update radio,etc