What do you want to save?
Add Code snippet
New code examples
-
SQL 2022-02-14 10:50:01
how to get one year old query from plan cache
SELECT TOP 10 t.TEXT QueryName, s.execution_count AS ExecutionCount, s.max_elapsed_time AS MaxElapsedTime, ISNULL(s.total_elapsed_time / 1000 / NULLIF(s.execution_count, 0), 0) AS AvgElapsedTime, s.creation_time, ISNULL(s.execution_count / 1000 / NULLIF(D... Add solution -
Best helpers
Ranking is empty