SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Nicholas Williams

SQLServerCentral.com profile

   Items 1 to 6 of 6   
 

sp_what

Better* than sp_who2, with less re-checking data to get answers. Also, it is SnaZy. With a capital Z. *Dont you just love totally non subjective assessments like this?  Read more...
By Nicholas Williams 2018/11/01 | Source: SQLServerCentral.com | Category: blocks
Rating: |  Discuss |   Briefcase | 592 reads

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.  Read more...
By Nicholas Williams 2015/07/23 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,249 reads

Recent Restore History

This script simply returns the most recent restore information about databases for a server. Returns the destination database name, the device used to perform the restore and the restore date.  Read more...
By Nicholas Williams 2015/07/15 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 672 reads

Email SP Results

Will take a stored procedure and email the results in a dynamically generated embedded HTML table or as an attachment.   Read more...
By Nicholas Williams 2016/12/05 | Source: SQLServerCentral.com | Category: email
Rating: |  Discuss |   Briefcase | 2,628 reads

Disk Capacities

Provides information on the total and used space for all drives on an instance.  Read more...
By Nicholas Williams 2013/12/06 | Source: SQLServerCentral.com | Category: disk
Rating: |  Discuss |   Briefcase | 4,613 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 7,312 reads
   Items 1 to 6 of 6