sqlguy-736318 (12/5/2016)
I'm trying to get a better understanding of relative performance expectations for different types of queries. For example, given a typical SS configuration, what type of response time would you expect for the following scenarios:* select 1 row of data from a single table which only has 1 row
* make 10 select statements, 1 select statement against 10 different tables, with each of the 10 tables having only 1 row
If I'm understanding your question correctly, the answer is somewhere around: 00:00:00
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho