Statistics Outdated
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
193 reads
Scripts
2018-03-19 (first published: 2018-03-15)
421 reads
Unused Indexes in your databases
This Script allows you to determine the list of unused indexes in your databases.
For sys.dm_db_indexes_usage_stats, make sure that the last rebbot of the service sql allows you to conclude
2018-03-06 (first published: 2011-02-10)
6,119 reads
2018-02-28 (first published: 2018-01-10)
3,073 reads
Custom Replication Status Record Latency Monitor
Monitors replicated tables for any publisher/subscriber for latency in record counts, alerts via email if latency exists beyond a specified threshold
2018-02-27 (first published: 2015-01-23)
510 reads
2018-02-23 (first published: 2018-02-19)
146 reads
2018-02-19 (first published: 2018-02-07)
982 reads
Compression estimates
The script estimate compression benefits per each object in the database for which the page compression has not been implemented.
2018-02-15 (first published: 2018-01-15)
1,926 reads
2018-02-12 (first published: 2018-01-24)
311 reads
Run SQL/T-SQL scripts on folder
What to do when you have several sql scripts to run in your DB? Put all in a folder and use this...
2018-02-09 (first published: 2018-01-24)
2,125 reads
Blogs
Learning Database Design and Power BI Performance
I spend my days working on and managing SQL Server instances—working days at least,...
Free SQL Training: Dive into Databases This December!
Want to learn SQL and get some real practice this December? Check out the...
Monday Monitor Tips: CIS Compliant
By Steve Jones
A new feature added to Redgate Monitor Enterprise automatically. CIS compliance is something many...
Forums
Merry Christmas 2025
Comments posted to this topic are about the item Merry Christmas 2025
The Reindeer Count
Comments posted to this topic are about the item The Reindeer Count
Events of System_health extended event serious or not
I have listed the event names present in my system_health extended event report. Based...
Question of the Day
The Reindeer Count
How many reindeer does Santa have pulling his sleigh? (according to the famous song) Hint, the answers are not base 10.
See possible answers