SQL Server Browser

SQL Server Preproduction Tasks

What are some of the things that you need to do before you sign off and hand it over to production? What do you need to do to keep the server running smoothly?

SQL Server Browser

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