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)
824 reads
Script to get any current requests with missing indexes
2016-03-11 (first published: 2014-09-11)
2,760 reads
Reports on the data and log file sizes and space used within files for each database on a servers. It also includes the free space on the drive where the file is located.
2016-03-10 (first published: 2015-07-23)
5,299 reads
This function is used to get the complete table lists are particular table and its last access datetime.
2016-03-07 (first published: 2014-11-03)
3,183 reads
This Script can be used to pick out a temporary table from tempDB
you might want to Check and drop the table before you create it just in case , but I Haven't included it here
2016-03-01 (first published: 2012-12-07)
1,799 reads
Following script retrieves the queries currently executing on the server.
2016-02-29 (first published: 2014-09-04)
3,325 reads
We can check for null values using count.
2016-02-26 (first published: 2016-02-16)
1,182 reads
SQL Agent job to cleanup all old text files on the errorlog directory.
2016-02-25 (first published: 2016-02-23)
454 reads
If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.
2016-02-24 (first published: 2016-02-19)
6,096 reads