Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Roshan Joe Joseph

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

Truncate tables with foreign keys

Truncating tables with constraints always had been a pain, since we have to drop and recreate all the FKs. I created a script that takes care of dropping and recreating the foreign keys while truncating. Please use with caution! and always respect your Data !  Read more...
By Roshan Joe Joseph 2016/12/01 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 482 reads

Quick check server space and DB size

Script to quickly check the drive space utilization.   Read more...
By Roshan Joe Joseph 2016/09/20 | Source: SQLServerCentral.com | Category: server space
Rating: |  Discuss |   Briefcase | 690 reads

Custom cleanup procedure for backup files

There are times when maintenance plan is too simple to do the job, and SSIS is unreachable for you. Here is a simple stored procedure to help you.   Read more...
By Roshan Joe Joseph 2009/11/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,475 reads

Script to find latest backups for all databases

If you are not the only one who takes care of the backups, knowing the backups taken recently is very crucial for a production DBA.  Read more...
By Roshan Joe Joseph 2009/07/01 | Source: SQLServerCentral.com | Category: backup and restore
Rating: |  Discuss |   Briefcase | 2,277 reads

Automate drive space monitoring for all production servers

Monitoring space in production server is one of the top priority tasks for a DBA. This script will automate it   Read more...
By Roshan Joe Joseph 2011/04/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,922 reads
   Items 1 to 5 of 5