Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
This one line DOS script fetches Hardware Make and Model
OS Name, Edition (for 2003) and version
A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]