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

Didn't find what you were looking for?