Using SQL Server Data Mining Add-Ins for Office 2007 to Predict Database Growth Trends - Part 2

I want to show you another easier way to pull information to help predict database growth again using the Data Mining Tools.

Find information about all databases

ALL database information

Database Growth History

This script uses the backup tables to get info on the growth of your database files.

Growth remaining for SQL Server 2005 databases

This script is little bit similar to the one posted for SQL Server 2000 that finds how much space you have left.

Security

How to Drop Unused Empty Redundant columns

Often during the development lifecycle columns are added to tables that become redundant or remain unused.
this script removes unused (empty) columns

How to get list of Stored Procedure

You can use following stored procedure with four optional input parameters to get a list of all stored procedures in the current environment.

Set standard database options

Ensure all your databases have standardised options by running this script weekly.

RE: URGENT... Help needed with xp_cmdShell

Thanks.Changing option in EM/Mgmnt/server Agent/JobSystem worked ok!   

RE: Inserting records and appending additonal items to the new record

Another quick and dirty approach that uses a temporary table instead of a cursor:--DROP TABLE letters GO CREATE TABLE letters (   ref int,   note varchar(1000) )SET NOCOUNT ON INSERT letters (ref, note) VALUES (1, 'Ref 1 Note A') INSERT letters (ref, note) VALUES (1, 'Ref 1 Note B') INSERT letters (ref, note) VALUES […]