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

Scripts by Haden Kingsland (theflyingdba)

SQLServerCentral.com profile

   Items 1 to 10 of 10   
 

Quick and dirty script to ascertain datafile headroom

This is quick script to ascertain datafile headroom based on current size of the data in a file against the max size (which needs to be set for this to work!)  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 285 reads

Generic, parameterised, create DB script

A script to be used as part of development deployments where new databases are required, so as to provide standardisation.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 363 reads

Log and report on table growth for trending

Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.  Read more...
By Haden Kingsland (theflyingdba) 2016/06/09 | Source: SQLServerCentral.com | Category: tables
Rating: |  Discuss |   Briefcase | 797 reads

DBCC CHECKDB to a table

An enhanced version of a script originally posted by Robert Pearl some time ago. It now takes into account changes in the tabelresults for CHECKDB in latter versions of SQL Server.  Read more...
Rating: |  Discuss |   Briefcase | 643 reads

End to End Server Disk Space reporting within SQL Server

This procedure using OLE object calls to obtain server disk space values and writes them to a table. It then creates an HTML report based on the contents of the table and then , via a SQL Agent job, sends out colour coded emails relating to how much drive space is left... this is very handy!!!!  Read more...
Rating: |  Discuss |   Briefcase | 939 reads

Part 2 -- Restore a database to another instance...

This script should be created in the source instance of the database to be backed up and then restored in conjunction with that on the destination in Step 1.  Read more...
By Haden Kingsland (theflyingdba) 2016/03/15 | Source: SQLServerCentral.com | Category: restore
Rating: (not yet rated) |  Discuss |   Briefcase | 523 reads

Part 1 -- Restore a database to another instance...

A great script that I wrote some time ago to allow the last database backup to be restored across a linked server to another server, after running a remote sproc on the destination to kill off any users on the receiving side.  Read more...
By Haden Kingsland (theflyingdba) 2016/03/14 | Source: SQLServerCentral.com | Category: scripts
Rating: |  Discuss |   Briefcase | 698 reads

SQL Agent job to show SQL Server service details upon agent restart

To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.  Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 549 reads

Enhanced Index Rebuild Script

Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.  Read more...
Rating: |  Discuss |   Briefcase | 1,182 reads

Generic SQL backup with Azure support

Generic SQL backup with Azure support allowing several, handy backup options.  Read more...
By Haden Kingsland (theflyingdba) 2016/01/29 | Source: SQLServerCentral.com | Category: backups
Rating: (not yet rated) |  Discuss |   Briefcase | 308 reads
   Items 1 to 10 of 10