February 18, 2016 at 11:12 am
we are in the process of upgrading from 2008r2 to 2014
I have run the 2014 upgrade advisor, but something came up that was not noted in the advisor reports, specifically, FASTFIRSTROW being removed in sql 2012
Is that because I would only see that if I were to run the 2012 upgrade advisor, in addition to the 2014 upgrade advisor? Or does neither version of the advisor pick up this kind of thing (i.e. would I have to rely solely on books online [Database Engine Backward Compatibility] to get this information)?
February 18, 2016 at 12:53 pm
the upgrade advisor is letting you know you have a query that contains the hint FASTFIRSTROW, support for this has been dropped since sql server 2012. You'll need to rewrite the query before upgrading to sql server 2014
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 18, 2016 at 2:21 pm
the advisor is NOT telling me about the FASTFIRSTROW, I got an error when I ran a query
Is that because I would only see that if I were to run the 2012 upgrade advisor, in addition to the 2014 upgrade advisor? Or does neither version of the advisor pick up this kind of thing (i.e. would I have to rely solely on books online [Database Engine Backward Compatibility] to get this information)?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply