FirstOnly property work and influence SQL Server query? It seems obvious, but in fact it is not.Problem description
Analyse how a query is translated into SQL Server query based on
FirstOnly property.Solution
Based on the description in msdn
FirstOnly property is a hint for database that only one record is required. Let's run several tests to analyse how it actually works. You can also jump to the conclusion section.