FASTFIRSTROW table hint is deprecated

Starting with SQL Server 2008, the FASTFIRSTROW table hint has been deprecated. This feature has been removed in  SQL Server 2012.

Use [FAST n] instead.  FASTFIRSTROW  allows data to begin streaming to the user earlier, at a risk of a cost in performance.  OPTION (FAST 1) is equivalent but you can, with this hint, specify the number of ‘fast’ rows. 

Available in

 SQL Code Guard