If you are using Full Text search, the internals of this have been rewritten for SQL Server 2008. If you moved from SQL Server 2000 to 2005 and made no optimisations to your FT code, it should work well in 2008. If you have optimised your FT code to get the most out of 2005, it may not work as fast in 2008.
If you were using Notification Services in SQL Server 2005, you will need to download and install the separate NS package for 2008, as NS is no longer included in the product.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara