Script to find table sizes in a database

Script to find table sizes in a database

sp_tables

Query text during caching in SQL 2005

SQL Server Service Check Utility

Script will display current status of SQL server services and even show if not installed. Works on SQL 2005,2008 2008R2. Both 32 and 64 bit servers.

Get SQLServer Name and Uptime SPROC

Stored procedure to provide clean output of system name and uptime since last restart

Top 10 Mistakes When Building and Maintaining a Database

Building and maintain a SQL Server database environment takes a lot of work. There are many things to consider when you are designing, supporting and troubleshooting your environment. This article identifies a top ten list of mistakes, or things that sometimes are overlooked when supporting a database environment.

Instant File Initialization

Activity Monitor Permission

T-SQL generator for sp_configure

The purpose of this code is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from.

Automate Your Backup and Restore Tasks

A new article that shows how you can automate a basic function that many environments need: the backup of a production database and the restore on a development system.