Starting SQL 2008, we have had Query Hash column in sys.dm_exec_query_stats. It helps group common queries together, because when SQL Server is generating execution plan
Tag: CTE
Getting Index count for all tables
Davide Mauri wrote a nice script, I have done similar work without using CTE. So I really liked the script; I notice in his comments