Statistics Outdated
Busca por todas as estatísticas que estão desatualizadas com base no threshold do TraceFlag 2371.
2018-03-21
219 reads
Scripts
2018-03-19 (first published: 2018-03-15)
453 reads
SQL Battleship
It's you versus the computer in the classic game of Battleship, completely playable from the SQL Server Management Studio interface!
2018-03-12 (first published: 2014-04-25)
8,478 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,162 reads
2018-02-28 (first published: 2018-01-10)
3,112 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)
580 reads
2018-02-23 (first published: 2018-02-19)
179 reads
2018-02-19 (first published: 2018-02-07)
1,026 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)
2,065 reads
2018-02-12 (first published: 2018-01-24)
335 reads
Blogs
T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget
I am excited to host T-SQL Tuesday for the first time. I want to...
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Forums
Measuring Productivity
Comments posted to this topic are about the item Measuring Productivity
Importing Excel files into SQL Server using DuckDB and Python
Comments posted to this topic are about the item Importing Excel files into SQL...
Tracking All the Queries
Comments posted to this topic are about the item Tracking All the Queries
Question of the Day
Tracking All the Queries
I have 3 instances of a brand new long running query that are executing on a SQL Server 2025 instance. Query store is enabled. One of the queries is killed by the administrator, one is cancelled by the user. The other runs to completion. How many rows are in Query Store for this query?
See possible answers