OpsDB - SQL Server Scripts

		Search
Categories	Sort by	< PREVIOUS PAGE 1 of 3 NEXT PAGE >

SQL_CreateAndAnalyzeTRACE

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	12550
Date	Mon 07/14/2008 @ 02:05
Author	Gilles Comeau
EMail	Gilles.Comeau@microsoft.com

RATING: COMMENTS (1)

SQL_UnRestrictDBSize

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

File size	3 K
Downloads	10836
Date	Tue 06/03/2008 @ 08:37
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

SQL_SuperBCP

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

File size	1 K
Downloads	11678
Date	Tue 06/03/2008 @ 08:36
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

SQL_StatisticsREPORT

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	11213
Date	Tue 06/03/2008 @ 08:35
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

SQL_SQLDiag

This script allows you to capture SQLDIAG information that is requested by PSS.

File size	9 K
Downloads	11046
Date	Tue 06/03/2008 @ 08:33
Author	SQL Server Community
EMail	sqlgurus@sqlcommunity.com

RATING: COMMENTS (0)

SQL_SmartINDEX

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	11640
Date	Tue 06/03/2008 @ 08:32
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

SQL_SmartBACKUP

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	10858
Date	Tue 06/03/2008 @ 08:30
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

SQL_ServerSecurityREPORT

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	11091
Date	Tue 06/03/2008 @ 08:28
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

SQL_RoboPERF

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	11814
Date	Tue 06/03/2008 @ 08:26
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

SQL_ReIndeXER25

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	10675
Date	Tue 06/03/2008 @ 08:24
Author	Saleem Hakani
EMail	Saleem@sqlcommunity.com

RATING: COMMENTS (0)

< PREVIOUS PAGE

1 of 3

NEXT PAGE >