Browse by Tags

All Tags » sql server » cache » tablesample (RSS)
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: , , , , ,