Missing indexes in current requests

Script to get any current requests with missing indexes

Get file sizes of database files and free space on disk

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.

Last Accessed Datetime for table - Easiest way

This function is used to get the complete table lists are particular table and its last access datetime.

CASE IN ORDER BY

sorting data based on a particular value.

Recreate a temporary table from TempDB

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

Find Currently Running Query – T-SQL

Following script retrieves the queries currently executing on the server.

Validating null values in a column without using ISNULL or NVL.

We can check for null values using count.

Cleanup old text files on the errorlog directory

SQL Agent job to cleanup all old text files on the errorlog directory.

Change SQL Server Service Accounts with Powershell

If you need to change multiple SQL Server Services accounts across your environment, Powershell can do that for you.

Orphaned login report for all databases

Running the sp_change_users_login @Action=Report against all databases with a simple cursor wrapped around it.