2008-11-21
2,971 reads
2008-11-21
2,971 reads
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
2008-10-24
796 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
350 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)
282 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)
130 reads
By SQLPals
How To Gain Access To SQL Server When No DBA ...
By Steve Jones
Flyway is a command line tool with lots of options and parameters. Working with...
Gurus, there is a table which is very slow to query , it has...
Hi. I have a query that returns few rows (out of 7 table join,...
By Stewart "Arturius" Campbell
We are working on a project to migrate a client from a version of...