Neeraj Prasad Sharma

Neeraj Prasad Sharma is a Dot Net developer, who is amazed by the SQL Server query optimizer. For the last six years he has been experimenting and testing its default behavior and if something goes wrong his goal is to fix it.

Articles: 1

Performance Tuning

SQL Server Read Ahead Reads Example

SQL Server has many features that assist with providing the best query performance and one of these features is read ahead reads or prefetching. In this tip we look at how this relates to SQL Server query performance and the impact to the query.