It is really cool know that now that SQL Azure PaaS databases supports full text indexes which was earlier not. SQL azure PasS has serious limitations where some of the features that are supported in normal SQL server enterprise versions do not available.
One such feature was SQL server’s full text indexing. Alternative newly introduced features like “Azure Search” are arguably more preferred for newer implementations but however recently Microsoft has announced that full text search is available for SQL Azure PaaS databases. Detailed information on that is available in this link http://azure.microsoft.com/blog/2015/04/30/full-text-search-is-now-available-for-preview-in-azure-sql-database/.
Limitations on SQL azure PaaS databases are available on this link…
https://msdn.microsoft.com/en-us/library/azure/ee336281.aspx
Sirisha Chamarthi
May 23, 2015 at 8:10 am
I validated the functionality of this and here is my experience with it: http://www.sqlindepth.com/full-text-search-in-sql-azure/
LikeLike