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!)
2017-05-02 (first published: 2017-04-19)
376 reads
A script to be used as part of development deployments where new databases are required, so as to provide standardisation.
2017-01-23 (first published: 2017-01-18)
453 reads
Log and report on table growth for trending, so you can track exactly which table(s) are your hotspots for growth.
2016-06-09 (first published: 2016-05-05)
1,739 reads
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.
2016-05-04 (first published: 2016-04-20)
1,238 reads
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!!!!
2016-03-16 (first published: 2016-02-25)
1,114 reads
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.
2016-03-15 (first published: 2016-02-25)
1,590 reads
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.
2016-03-14 (first published: 2016-02-25)
826 reads
To show SQL Server and physical server details upon instance restart so that we have visibility of unexpected issues with servers and services.
2016-02-18 (first published: 2016-02-04)
729 reads
Enhanced version of Index Rebuilt Script originally written by Michelle Ufford, which now includes latest version updates and additional features.
2016-02-17 (first published: 2016-02-04)
1,821 reads
Generic SQL backup with Azure support allowing several, handy backup options.
2016-01-29 (first published: 2016-01-21)
369 reads
By Steve Jones
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so...
By Kevin3NF
Too many IT teams run index rebuild jobs on autopilot. Every night. Every index....
If you're a data analyst juggling varied datasets, mastering SQL data type conversions isn't...
I have a record, in those the three columns where firstname / last name...
Comments posted to this topic are about the item Execution Plan Operators
--for a given member if the startdate and endate is continous we need to...
When looking at an execution plan in SSMS, what types of operators are shown?
See possible answers