Can you shrink your SQL Server database to death?

To increase SQL Server disk space, 'shrink the database' task is used. But the tests in this tip using autogrowth prove that 'shrink database' poorly impacts SQL performance.

Managing SQL Server Database and Application Metadata

Unless you are the Database Administrator or the Application Analyst for a particular database you are usually oblivious to the naming conventions of the databases that support the applications you rely upon daily. This is why it is important to have the metadata repository in place to provide that translation when the need arises.

Automatically Running Stored Procedures at SQL Server Startup

I have a stored procedure I want to run when SQL Server starts. Is there a way to execute this procedure automatically each time the SQL Server service is started?

Terminate User processes in SQL Server

This article illustrates how to create a simple procedure to kill many sessions at the same time, kill a range of sessions and kill all of the sessions connecting to a database.

Renaming a Database

Expert trainer and longtime DBA, Andy Warren, tackles the rather simple, but often understood, process of renaming a database. Learn about some of the issues you might encounter when trying to complete this task.

Importance of the Resource Database

This article describes the importance of the Resource database in SQL Server 2005 & 2008

DB File Extension

Kill Database sessions

This script will kill the user sessions on a specified database.

Moving TempDB

One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.

The Ultimate Table Searcher

Searches for tables who's names contain the search string. Gives Size and Rows information as well.