Monday, January 05, 2009 Register   Login   
   You Are Here: Scripts/Tools » OpsDB - Operations Database for SQL Server      
 Recently Submitted Articles
  
 Recent SQL Clinic Articles
  
 SQL Community Portal
  
 OpsDB SQL Server Tools (SQL Server Automation)

     

 
Search
Categories
 Sort by

< PREVIOUS PAGE

 1 of 3 

NEXT PAGE >
SQL_CreateAndAnalyzeTRACE
Thumbnail

This script creates a trace, loads it into SQL and then prints out the worse running stored procs for analysis.


File size 6 K
Downloads 184
Date Mon 07/14/2008 @ 02:05
Author Gilles Comeau
EMail Gilles.Comeau@microsoft.com
RATING:   COMMENTS (1)  

DOWNLOAD

SQL_UnRestrictDBSize
Thumbnail
This script allows you to unrestrict the growth size of all the databases.

File size 3 K
Downloads 81
Date Tue 06/03/2008 @ 08:37
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_SuperBCP
Thumbnail
Generates a script for exporting data from all the tables of a database.

File size 1 K
Downloads 129
Date Tue 06/03/2008 @ 08:36
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_StatisticsREPORT
Thumbnail
This script helps in finding out how many records were inserted/updated/deleted since the last time statistics were updated.

File size 2 K
Downloads 98
Date Tue 06/03/2008 @ 08:35
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_SQLDiag
Thumbnail
This script allows you to capture SQLDIAG information that is requested by PSS.
File size 9 K
Downloads 97
Date Tue 06/03/2008 @ 08:33
Author SQL Server Community
EMail sqlgurus@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_SmartINDEX
Thumbnail
This script allows you to obtain fragmentation information from tables and indexes of your local SQL Server. It also provides you with recommendation based on the amount of fragmentation detected in tables/indexes. It also has a feature that lets you generate a script for rebuilding or re-organizing all the indexes.


File size 7 K
Downloads 121
Date Tue 06/03/2008 @ 08:32
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_SmartBACKUP
Thumbnail
Allows you to perform FULL, DIFFRENTIAL, & Log SQL Server backups using SQL Lite Speed. It can also allow you to take individual backups or can allow you to perform backups on all the databases.

File size 6 K
Downloads 85
Date Tue 06/03/2008 @ 08:30
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_ServerSecurityREPORT
Thumbnail
This script displays logins and their server related permissions. It also provides you with an for those accounts that have System Admin privileges.

File size 1 K
Downloads 90
Date Tue 06/03/2008 @ 08:28
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_RoboPERF
Thumbnail
SQL_RoboPERF procedure provides you with the following information:

1) HIGHCPU - Top 50 statements that are CPU intensive'
2) LOCKS - Detect real time locking information'
3) TempDBData - View current SQL Statements from TempDB'
4) SQLJobs - View SQL Server Job details'
5) IndexUsage - View which indexes are being used'
File size 9 K
Downloads 140
Date Tue 06/03/2008 @ 08:26
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

SQL_ReIndeXER25
Thumbnail
This script will re-index all the indexes from a given database (if DBName is passed as a parameter) or from all the databases if no parameters passed.

File size 3 K
Downloads 70
Date Tue 06/03/2008 @ 08:24
Author Saleem Hakani
EMail Saleem@sqlcommunity.com
RATING:   COMMENTS (0)  

DOWNLOAD

< PREVIOUS PAGE

  1 of 3  

NEXT PAGE >
Syndicate    
SQL Server 2000 Downloads
 
SQL Server 2000 Reporting Services Downloads
 
SQL Server 2000 Notification Services SP Downloads
 
SQL Server CE Downloads
 
SQLXML 3.0 Service Pack Downloads
 
SQL Server 2000 JDBC Driver
 
MDAC 2.6 Download
 
SQL Server 2000 Tools Downloads