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.

Upgrading to SQL Server 2005: A dozen must-have tips

We've compiled a list of our dozen most popular tips in the area of upgrading to SQL Server 2005 and they run the gamut.

You have just purchased a brand new 64-bit...

Setting Up Delegation for Linked Servers

Learn how to set up delegation on your SQL Server instances, so you can use the impersonate options when setting up the security properties of linked server definitions.

Finding Column Dependencies

Most experienced DBAs know that sysdepends is not very reliable, so how can you find the dependencies inside your database? New author Christian Buettner brings us his technique for finding those hidden dependencies based on your query plans.