I would like to describe what is meant by "read-ahead reads" after having set "set statistics io on;".
Do you know where I could find information about it which is valid for SQL Server 2005? In MSDN and Google, I just found information for older versions of SQL Server.
Is this source http://www.microsoft.com/technet/prodtechnol/sql/70/reskit/part4/sqc05.mspx - which explaines quite well what I need - still valid for SQL Server 2005?
Thanks for help,
Read ahead reads are still available in SQL Server 2005.
Visit my SQL Server weblog @ http://dis4ea.blogspot.com
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?