tags:

views:

20

answers:

0
Q: 

Problems when going from SQL 2005 to SQL 2008

Hi!

I did go over from SQL server 2005 to 2008. Doing that gave me some problems with the fulltext search. This site is based on Fulltext search.

  • It occurs more deadlocks,
  • the search is slower
  • and sometimes it return empty lists, don't know why.

A lot of people has been writning about they having this problem with 2008. But I haven'tgot any solutions why 2005 worked better for my program..

PLS help me out!

related questions

Which search technology to use with ASP.NET?
Best text search engine for integrating with custom web app?
In-house full-text search engine for source code and SQL scripts
How to implement in-process full text search engine
What are the full-text search tools you can use in SQL Server?
Make SQL Server index small numbers
How do I compare phrases for similarity?
How to do hit-highlighting of results from a SQL Server full-text query
LinqToSql and full text search - can it be done?
What are some Search Servers out there?
When should you use full-text indexing?
SQL Server Freetext match - how do I sort by relevance
Upgrade database from SQL Server 2000 to 2005 -- and rebuild full-text indexes?
How do I do full-text searching in Ruby on Rails?
SQL Server Full-Text Search: Hung processes with MSSEARCH wait type
MS SQL FTI - searching on "n*" returns numbers
Searching subversion history (full text)
How to implement a "related" degree measure algorithm?
Best full text search alternative to ms sql, c++ solution
How do you full-text search multiple criteria on left-joined tables in SQL Server?
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
SQL Server Full Text Searching
How to enable Full-text Indexing in SQL Server 2005 Express?
How do you get leading wildcard full-text searches to work in SQL Server?
Why doesn't SQL Full Text Indexing return results for words containing #?