Statistics

SQL agent question

SQL Server Script to Create Windows Directories

An interesting script to handle file tasks from within SQL Server.

DBA Morning Check List

This article helps the DBA find and fix issues quickly by creating a DBA Morning Checklist.

Analyze and Correct a large SQL Server MSDB Database

It has come to my attention that some of our MSDB databases are getting what I would consider large for a system database. Some of our MSDB databases are over 2 GB which is a little perplexing because I know we do not create any user defined objects in that database. Can you give me some insight into the issue? I know we have this issue with both SQL Server 2000 and 2005 instances.

Backups

When sp_depends fails

sp_depends may not always return accurate information

Delete files older than n-days via T-SQL

Delete files on a fileshare leaving behind files not older than n-days.

Moving System Databases

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.