In this script we create a temporal table and then review all indexes with next conditions.
avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 %
2008-09-05 (first published: 2008-07-10)
4,622 reads
This script utilize the DMV to quickly build the locking block-chain.
2008-09-05 (first published: 2008-07-10)
2,667 reads
A script that can generate a massive amount of data relatively quickly
2008-09-04 (first published: 2008-07-11)
1,311 reads
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
2008-08-27 (first published: 2008-02-15)
2,557 reads
Get a report of all your SQL jobs in HTML Format
2008-08-27 (first published: 2008-07-03)
2,160 reads
To import the SQL Server error log into a table, so that it can be queried
Written by: Anand Mahendra Tested on: SQL Server 2000
2008-08-21 (first published: 2008-06-30)
752 reads