Comments by Member 10441509

Member 10441509 17-Sep-15 8:16am View

it gives error:-

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view '#tempnews' because it is not full-text indexed.

Member 10441509 17-Sep-15 6:58am View

Because even without using user function like query takes almost same time but contains took only 2:15 mins

Member 10441509 17-Sep-15 5:28am View

Table size is 7GB which is heaving more than 450k records.

if run like query it is giving result in 2hrs,So can not use like .

Member 10441509 17-Sep-15 4:51am View

select top 10 dbo.udf_StripHTML(NewsDescription) as mydesc ,* from newsdetails where contains(mydesc, '"fiber"')

but gives error

Invalid column name 'mydesc'.

Member 10441509 17-Sep-15 4:48am View

Incorrect syntax near '('.

Comments by Member 10441509 (Top 5 by date)