Tuesday, July 10, 2007 - Posts

SQL Server 2005 Query optimization issue : limit affected rows on a large volume table?
10 July 07 03:40 AM | SQL Master | 1 Comments   

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 Read More...

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