Know read and write ratio before you tune database performance

A script to get the user table query ratio and update radio,etc

Find SQL Services and Accounts

Find SQL Services and what account they run under with Powershell

SQL server Service, Account, Trace Flag info

This script outputs sql server service, start type, status, Service Account, installation location, start up time, uptime of sql server related services along with startup trace flags.

Script to configure Log File Size for Large DBs

Use this script to set recommended Log files size growth for larger DBs. For more, please refer article: http://sqlmag.com/blog/choosing-default-sizes-your-data-and-log-files

Check FileSize and LogUsage for all DBs

This script provide informations about SQL DBs files size and Log usage.
This little script use os_performance_counters

Faster Log Shipping Restores

When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.

Estimate compression for all tables and indexes with both Row and Page

This will log output of estimate compression for both PAGE and ROW for all tables and indexes

Getting transaction log space usage statistics for all databases.

Easy way to get the TLOg space Usage details

SQL Jobs on Always On

This script will check the status of the node in Always On and enable or disable the jobs according to our requirement.

HashBytes Nvarchar(MAX)

SQL SERVER Includes a Hashbytes function, however it's limited to VARCHAR(8000). This can cause a problem when trying to build hashes over wide datasets.

Solution

Expose the C# Hashbytes function using CLR