Browse by Tags

TSQL to list the most used query plans

Published 28 September 7 3:12 AM | SSQA.net

select TOP 100 objtype, p.size_in_bytes, LEFT([sql].[text], 100) as [text] from sys.dm_exec_cached_plans p outer apply sys.dm_exec_sql_text (p.plan_handle) sql ORDER BY usecounts DESC...( read more ) Read More...

Filed under: sql server, query, plan, tsql, execution, cached

FIX: Error message when you run a query that selects many columns and that joins many tables in SQL Server 2005 Service Pack 2: "The query processor could not produce a query plan"

Published 30 August 7 1:42 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, query, plan, kba, service pack2, processor

Cached query plans and top stored procedures that are recompiled

Published 11 May 7 6:2 AM | SqlServer-QA.net (SSQA)

We all know that the cached query plans are good to go to attain the performance and no doubt that inefficient query plan will cause more distress to performance with an increased spike in CPU consumption. At the same occurrence of recompilation of a...

Filed under: sql server, package, indexes, query, perfmance, plan, cache