Browse by Tags

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

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