SQLtools

scripts to tune and optimize SQL queries

CompiledParameterValues get compiled parameter values from a specific Stored Procedure name
ExportSQLUser is used for exporting users on a SQL instance and then create users on a new SQL instance
GetBlockSize.ps1 checks the cluster size of disk volums.
MissingIndex.sql create a report of missing indexes.
ParameterSniffing.sql shows queries that has high read variance in plans that indicates parameter sniffing issue
RunningQueries.sql displays current running queries along with cursors and their plan
SearchExecPlansWithParams.sql search for plans ordered by last logical reads with their compiled parameter values.
VLFCounts.sql detects high VLF counts which can be a problem with time used on restore.
CreateRSExecRole.sql creates the custom SSRS databaserole used for subscriptions. Useful for AlwaysOn environment.

Name		Name	Last commit message	Last commit date
Latest commit History 100 Commits
ChangeColumnCollation.sql		ChangeColumnCollation.sql
ColumnwithdiffCollation.sql		ColumnwithdiffCollation.sql
CompiledParameterValues.sql		CompiledParameterValues.sql
CreateRSExecRole.sql		CreateRSExecRole.sql
ExportSQLUsers.sql		ExportSQLUsers.sql
GetBlockSize.ps1		GetBlockSize.ps1
HumanEvents.sql		HumanEvents.sql
IndexSpool.sql		IndexSpool.sql
MissingIndex.sql		MissingIndex.sql
ParameterSniffing.sql		ParameterSniffing.sql
ParameterSniffingCPUtime.sql		ParameterSniffingCPUtime.sql
README.md		README.md
RunningQueries.sql		RunningQueries.sql
SearchExecPlansWithParams.sql		SearchExecPlansWithParams.sql
TrimSQLXML.ps1		TrimSQLXML.ps1
VLFCounts.sql		VLFCounts.sql
createplan.sql		createplan.sql
dataskew.sql		dataskew.sql
renameDB.sql		renameDB.sql
restoreBAK.ps1		restoreBAK.ps1
sqlplanxmltrim.ps1		sqlplanxmltrim.ps1
testplan.sql		testplan.sql

Provide feedback