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
 

Data_Size 

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
 

SP_Kill_Users 

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