Browse by Tags

TSQL to get TOP 10 queries that are using I/O generation, SQL Server 2005

Published 14 July 8 5:26 AM | SSQA.net

DMVs are most helpful to find instant information on SQL instance without causing further delays, in any performance degradation time you can execute following TSQL to get top 10 queries that are generating lots of I/O on the server: SELECT TOP 10 total_logical_reads...

Filed under: sql server, dmv, tsql, sysindexes, query plan, querystats

FIX: Error message when you run a DELETE statement from a table that contains a nonclustered primary key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"

Published 23 June 8 8:30 PM | SSQA.net

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

Filed under: sql server, query, kba, processor, delete, query plan, statement, internal

Show text from sql_handle

Published 4 October 7 5:50 AM | SSQA.net

Based upon the query or stored procedure execution the plan will be stored in the cache, but it may not be in readable format as it is stored in Hexadecimal when you simply query SYSPROCESSES table. So in order to extract the query plan that is in cache...

Filed under: sql server, performance, xml, top, tsql, execution, list, query plan, showpan