Check owners, collations and backups

A script to check the owners, collations and backups on the server.

2005 unused indexes

Shows unused indexes compared to nr of modifications

You need to perform a restore operation as...

usp_ShowOrphanUsers - SQL 2k

Check Orphaned logins ie, not associated with any database on the current instance.

Deadlock Notifications in SQL Server 2005

Deadlocks do not occur too often, but when they do, it can be a time consuming and frustrating endeavor to track them down. In SQL Server 2000, you could alter the message to ensure these were written to the error log and track them down quickly. In SQL Server 2005, it is a little more tricky, but new author Patrick Leblanc brings us a technique for sending out a notification.

Max Actual datalength

This script returns the defined rowlength and the actual datalength for the longest row in a table.

Show Table, Index and Image/Text size.

This is a simple script that show size from a table and yours related objects.

Which security modes are supported by Service Broker?

While restoring your SQL Server 2005 database's transaction...

Changing Service Credentials

One day, you may need to change those service credentials under which your SQL Server services normally run. If you have a number of servers, then you'll really want to read about Rodney's solution.