Clickatech Slow SQL

SQL Slow Performance

Useful SQL to check your indexes. If avg fragmentation is larger than 15% consider rebuilding the indexes: SELECT OBJECT_NAME ( object_id,database_id), * FROM [sys].dm_db_index_physical_stats, NULL, NULL, NULL, DEFAULT) AS ddips …

Clickatech Nintex

Nintex – Useful SQL Queries

This script will show you how many Workflow progress records each workflow in your environment has generated. SELECT i.WorkflowName, COUNT(p.InstanceID) [Number of WF Progress Records], i.siteid, i.webid, i.listid FROM dbo.workflowinstance …