SQL Server Central: Content tagged Maintenance and Management

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 | 746 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,804 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 | 551 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 | 573 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,320 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 | 859 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 | 730 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 | 547 reads

SQL Server 2005 Express Edition - Part 11 - ClickOnce Deployment and Maintenance Options

Part 11 of the series focuses on the process of deploying and maintaining user instance-based applications that employ ClickOnce technology. Read more...

By Additional Articles 2007/11/23 | Source: Database Journal | Category: SQL Server 2005 Express

Rating: (not yet rated) Rate this |

Briefcase | 1,051 reads