DBCC

Extract User-Role Mapping

This short script will list all the users along with their Roles.

The Ultimate PK-Less / CLIDX-Less Table Finder

Lists Schema/Object of tables that are missing a Primary Key or Clustered Index, along with aggregate data for size, rows, indexes, and columns.

The Ultimate Table Searcher Mk2

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

Managing Transaction Logs

A great article that should answer all your questions about the transaction log from MVP Gail Shaw. A must read for all DBAs.

Moving Large Table to Different File Group

How to Move Large Table to Different File Group

Get DB Files in directoy

get the database files existed in specified directory

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?