Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
2013-01-07 (first published: 2008-08-01)
21,322 reads
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,696 reads
2013-01-03 (first published: 2009-02-17)
8,229 reads
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,313 reads
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,373 reads
Reports index stats, index size+rows, member seek + include columns as two comma separated output columns, and index usage stats for one or more tables and/or schemas.
2012-12-27 (first published: 2008-08-01)
7,989 reads
This is a simple script that show size from a table and yours related objects.
2012-12-24 (first published: 2007-09-27)
2,729 reads
This script will query across all databases, returning a result of objects recently created or modified.
2012-12-21 (first published: 2012-11-27)
2,074 reads
2012-12-20 (first published: 2012-12-04)
1,723 reads
History table needs individual rows for each column that has been updated, i.e., a column history.
2012-12-17 (first published: 2012-12-04)
1,181 reads
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
How I used AI for this postChatGPT to generate images based on info specifically...
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
Comments posted to this topic are about the item How Can SQL Server Detect...
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers