Tag: dba
-
List of DMVs & DMFs available in SQL Server 2005
I’ve listed down all the DMV’s that are related to SQL server 2005
-
Backup Maintenance Plan with Cleanup task
This article provides a complete description about configuring backup using maintenance plan including cleanup task. This will be useful to junior DBA’s and also for the persons who have no voice in SQL server. This article is applicable for both SQL 2005 & SQL 2008.
-
Trigger Status
This will list out status of the trigger in a Database. This is compatible to SQL 2000 and 2005.
-
Table and Column Details
This script gives a detailed information about tables and thier associated column properties for each database. This lists out Database name, owner name, table name, column name, data type, collation, etc. This is compatible to SQL 2000 and 2005.
-
Table Space Details
This script will list out the details of the space used by each in a database.This is compatible to SQL 2000 and 2005.