 <p>Hard to say.</p> <ul> <li>Massive parallel queries?</li> <li>Thousands of small ones?</li> <li>OLTP or warehouse?</li> <li>CPU or IO or Memory bound?</li> <li>Server hardware and settings? MAXDOP, RAID etc</li> <li>Same set of data? (in buffer pool or lots of churning of in-memory data)</li> </ul> <p>We have 100 million rows tables with sub 1 second aggregate queries running many time during working hours, and 10,000 rows table queries that take 20 seconds but only run once at 4am.</p>