2008-11-21
2,996 reads
2008-11-21
2,996 reads
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
2008-10-24
801 reads
This one line DOS script fetches Hardware Make and Model
OS Name, Edition (for 2003) and version
System Uptime
Processors,
RAM etc.
2008-10-20
352 reads
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, […]
2007-06-21 (first published: 2006-01-30)
286 reads
As an administrator it is required sometimes to list out the job owners.This is a simple script that will allow to fetch this information. By applying a filter a specific job owner list can be fetched.
2006-11-21 (first published: 2006-01-30)
133 reads
This article provides a comprehensive overview of the ORDER BY clause within SQL window...
Want to build a data analytics foundation that transforms raw data into valuable business...
By Steve Jones
Recently a customer asked if SQL Compare and SQL Data Compare can be used...
I'm using the below connection string using providing UserID and password on their respective...
Comments posted to this topic are about the item Knowing Your Total Reward