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

• AnalyzeTraceFileFromSQLProfiler.sql - Query and analyze a tracefile from SQL Profiler