Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Scripts with tag
Maintenance and Management
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(335)
Lock and Connection Management
(35)
Administration
(2)
Job schedules
(1)
T-SQL Aids
(212)
Data Warehouse
(30)
Generate job schedules
(1)
Jobs
(1)
Backup / Restore
(88)
Replication
(17)
Job
(1)
SQL Server 2000
(1)
SQLInsider Scripts
(88)
Mail
(16)
Job history
(1)
T-SQL
(1)
Index Management
(49)
SQL Server 2005
(4)
Job Schedule
(1)
Search for
any
content tagged
Maintenance and Management
Add a script
Items 1 to 20 of 678
Next 20 >>
Verify Last successful CHECKDB on all databases
Creates a resultset that expresses the last time a successful CHECKDB was performed on every database in the instance. Does not work on SQL 2000.
Read more...
By
Kyle Neier
2008/04/29
|
Source:
SQLServerCentral.com
|
Category:
Administration
Rating:
|
Discuss
|
Briefcase
|
773 reads
SQL Server 2005 - Backup, Integrity Check and Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.
Read more...
By
Ola Hallengren
2008/04/15
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
2,920 reads
Display Job Schedule Description (SQL Server 2005)
The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/ Which did not work in SQL 2005 due to table changes on MSDB
Read more...
By
Cowboy DBA
2008/03/21
|
Source:
SQLServerCentral.com
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
565 reads
Generate Job Schedule Descriptions
A SELECT statement which includes the alpha description of each job's schedule
Read more...
By
Richard Sutherland
2008/01/07
|
Source:
SQLServerCentral.com
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
743 reads
Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
Read more...
By
Pedro Lopes
2008/01/11
|
Source:
SQLServerCentral.com
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
865 reads
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
Read more...
By
Pedro Lopes
2008/01/18
|
Source:
SQLServerCentral.com
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
582 reads
Update Statistics - All Tables (No System)
This proc executing the update statistics command in all user tables (no system).
Read more...
By
Benes Guislandi
2007/12/20
|
Source:
SQLServerCentral.com
|
Category:
Maintenance and Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
557 reads
Generate Drop / Create Script for views, stored Procedures
This Script generates drop and create scripts for views or stored procedures.
Read more...
By
doktor-kermit
2008/01/14
|
Source:
SQLServerCentral.com
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
1,326 reads
proc to order xp_enumerrorlog
Read more...
By
paul_richardson
|
Category:
Maintenance and Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
40 reads
Find Parent Child RelationShip
Read more...
By
Jorge Novo
|
Category:
Miscellaneous
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
88 reads
Database count using system tables
Read more...
By
Jorge Novo
|
Category:
Replication
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
129 reads
finding the blocks in sql server
Read more...
By
Paarthasarathy
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
921 reads
Get all user def table info with rowcount and size
Read more...
By
Mohit Nayyar
2007/11/19
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
3,219 reads
CPU Performance Check.
Read more...
By
Eshwaran
2007/11/20
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
1,517 reads
Display disk space stats for each table
Read more...
By
Andrew Greenall
|
Category:
Miscellaneous
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
275 reads
Table row count using 3 different ways
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,051 reads
Locate primary key - foreign key relations
Read more...
By
Mohit Nayyar
0001/01/01
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,460 reads
How to insert and update from remote linked server
Read more...
By
Chris Morton
2007/10/30
|
Category:
Replication
Rating:
|
Discuss
|
Briefcase
|
1,049 reads
Reseeding Identity values
Read more...
By
BASAVARAJU R
2007/11/02
|
Category:
Maintenance and Management
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
546 reads
Script to get Foreign key details
Read more...
By
BASAVARAJU R
2007/08/15
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
146 reads
Items 1 to 20 of 678
Next 20 >>
Most popular
SQL Server 2005 - Backup, Integrity Check and Index Optimization
Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.
Read more...
By
Ola Hallengren
2008/04/15
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
|
Discuss
|
Briefcase
|
2,920 reads
Monitor Database Growth
Read more...
By
Brandie Tarvin
2007/05/16
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
7,363 reads
usp_KillConnections
Read more...
By
Antonio
0001/01/01
|
Category:
Lock and Connection Management
Rating:
|
Discuss
|
Briefcase
|
5,229 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use