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)
20,995 reads
Search for a text in all the stored Procedures in a Database
2013-01-04 (first published: 2009-01-14)
3,626 reads
2013-01-03 (first published: 2009-02-17)
8,142 reads
To find a list of Tables (User or System tables)according to their size.
2013-01-02 (first published: 2008-07-10)
4,283 reads
This Script generates drop and create scripts for views or stored procedures.
2013-01-01 (first published: 2007-10-19)
6,325 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,928 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,708 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)
1,872 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,132 reads
2012-12-14 (first published: 2012-11-27)
1,909 reads
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
The post When is the perfect moment to build a data strategy in a...
In this step-by-step tutorial, learn how to run MySQL, PostgreSQL, MongoDB, and other stateful...
We are planning to migrate our on-premises SQL Server to an AWS PostgreSQL database...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
Comments posted to this topic are about the item Learn Microsoft Fabric: A practical...
If I want to rename the OldSales database to ArchiveSales, how can I do this? (choose 2)
See possible answers