2008-11-21
2,941 reads
2008-11-21
2,941 reads
Disk Fragmentation is one of the cause of degraded performance. Use this script for fragmentation analysis report.
2008-10-24
786 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
346 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)
278 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)
127 reads
SQL Server is a complex beast, with many configuration options that can range from...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
One of the frequently quoted ETL best practices is to disable your non-clustered indexes...
How to update table partwithcompany column name company id by companyid for max partid...
Hoe to get appt_time+duration = end_time can you please help on this
SQL server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....