SQLServerTools
This repo is the home of various SQL-Server-Tools for MS SQL-Server
-
MailJobTimeLine_DE.sql - This SQL (german, theres also a not actual english version MailJobTimeLine.sql) sends an email with all jobs displayed in a graphical timeline: Exampletimeline
-
GetExecutionPlans.sql - Find executionplans
-
GetProcedureMetrics.sql - Get proceduremetrics
-
GetErrorLog.sql - Get/Read errorlog
-
GetIndexFragmentation.sql - Get index fragmentaion
-
GetExecutionAndInvokecount.sql - Get executionplans and count of invoke
-
FREEPROCCACHE.sql - Delete executionplan of specific object, see also GetExecutionAndInvokecount.sql to get the planhandle
-
GetConnections.sql - Get current connections
-
FindTriggers.sql - Find triggers
-
Top10WorstProcedures.sql - The TOP 10 of the worst procedures
-
SelectFlatFiles.sql - Run selects against flatfiles from a filesystem
-
ChangeOptionsInDatabases.sql - Executes an SQL on all or selected Databases
-
CleanupHistories.sql - Cleans up histories
-
OpenTransactions.sql - Shows all current transactions
-
ShowFragmentation.sql - Shows fragmentation, customize where-clause
-
GetSynonyms.sql - Get all synonyms of all databases
-
DeleteExecutionPlan.sql - Delete specific executionplans
-
GetStatisticSamples.sql - Get all statistics with a sample size < 100%
-
HallengrenHeaviestMail.sql - Sends an mail with the heaviest statisticsupdates of an hallengren maintenance
-
MailFragmentation.sql - Sends an mail with all indexes > 100 pages and >= 5% fragmentation
-
GetOldStatistics.sql - Get old statistics
-
TriggerDependencies.sql - Find dependencies to other tables in triggers
