Posts in Category: Database Administration

Create Insert 

Posted by Philip Leitch Tuesday, November 10, 2009 2:40:42 AM Categories: Database Administration Procedure

Creates an easy "Insert" script for transfering data, dynamically constructed based on the table:

e.g. Insert into '[XYZ] Values('test', 2,2,'Value')

... read more

Remove Backup History 

Posted by Philip Leitch Monday, November 9, 2009 6:11:50 PM Categories: Database Administration

Remove Backup History which will reduce the size of MSDB and also increase the speed of backup and restore routines.

... read more


Posted by Philip Leitch Wednesday, October 7, 2009 9:40:03 PM Categories: Database Administration View

Provides a way of viewing the size of tables, and what part of the table contribute to that size.

... read more


Posted by Philip Leitch Saturday, June 13, 2009 6:22:49 AM Categories: Database Administration Procedure

Kills all processes currently using a specified database, or all databases if no database is supplied.

... read more
Copyright 2009 Philip Leitch