Browse by Tags

Identifying top 20 most expensive queries in terms of read I/O (referred from Technet Magazine)

Published 15 November 7 7:16 AM | SSQA.net

It is worth mentioning the valueable query I have been through when referring to Technet Magazine, the following query has given me useful information in finding out what are my top 20 most expensive queries that are consuming most of disk I/O (read &...

Filed under: sql server, performance, microsoft, technet, dmv, top, tsql, reads, system resources, expensive query, identity, writes

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

SQL Server 2005 Query optimization issue : limit affected rows on a large volume table?

Published 10 July 7 5:40 AM | SSQA.net

If you have a huge volume of table (say millions of rows) and a requirement to limit x number or sample of rows from a query every time you execute. To limit number of rows then you would think about [ select ... from (select top 100 * from X order by...

Filed under: sql server, performance, query, cache, top, tablesample