<div>
&gt;&gt;A single SELECT statement can trigger multiple<br />
can you give an example of the above?<br />
<br />
SELECT * FROM PROGRESS_CARD<br />
<br />
will the above always be one read regardless of how many records are returned.?
</div>


>>A single SELECT statement can trigger multiple
can you give an example of the above?

SELECT * FROM PROGRESS_CARD

will the above always be one read regardless of how many records are returned.?

<div>
is there a way to test how many reads a select statement takes..<br />
<br />
sys.dm_io_virtual_file_sta<wbr />ts shows it for all the transactions going on.. how about just a single statement like...<br />
SELECT * FROM PROGRESS_CARD
</div>


is there a way to test how many reads a select statement takes..

sys.dm_io_virtual_file_stats shows it for all the transactions going on.. how about just a single statement like...
SELECT * FROM PROGRESS_CARD

<div>
<div class="content wysiwyg-content">
is one select statement = one read<br />
(referring to <br />
sys.dm_io_virtual_file_sta<wbr />ts.num_of_<wbr />reads)
</div>
</div>


is one select statement = one read
(referring to 
sys.dm_io_virtual_file_stats.num_of_reads)

what constitutes a read?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.