Answer / raj

SQL Server 2008 provides the functionality for applications
and users to issue full-text queries against character-based
data in SQL Server tables. Before full-text queries can be
run on a given table, the database administrator must create
a full-text index on the table. The full-text index includes
one or more character-based columns in the table. These
columns can have any of the following data types: char,
varchar, nchar, nvarchar, text, ntext, image, xml,
varbinary, or varbinary(max). Each full-text index indexes
one or more columns from the base table, and each column can
have a specific language. Beginning in SQL Server 2008,
full-text search supports more than 50 diverse languages,
such as English, Spanish, Chinese, Japanese, Arabic,
Bengali, and Hindi. For a complete list of the supported
full-text languages, see sys.fulltext_languages (Transact-
SQL).

For each supported language, SQL Server provides language-
specific linguistic components, including a word breaker and
stemmer and an empty thesaurus file. For each full-text
language, SQL Server also provides a file in which you can
optionally define language-specific synonyms to extend the
scope of search queries (a thesaurus file). In addition,
beginning in SQL Server 2008, a system stoplist is provided.
To support specific language or business scenarios, you can
alter the system stoplist by adding and removing stopwords
(also known as noise words), and you can create additional
stoplists as needed.

For writing full-text queries, SQL Server provides a set of
full-text predicates (CONTAINS and FREETEXT) and rowset-
valued functions (CONTAINSTABLE and FREETEXTTABLE). Using
these, applications and users can perform a variety of types
of full-text searches, such as searching on a single word or
phrase (and optionally ranking the result set), searching on
a word or phrase close to another word or phrase, or
searching on synonymous forms of a specific word.

Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

0 Answers  

---

Can sql servers link to other servers?

0 Answers  

---

How to retrieve data from log files in SQL SERVER ?????

1 Answers  

---

How to determine the service pack currently installed on SQL Server?

4 Answers   HCL,

---

Mention the different types of replication in sql server.

0 Answers  

---

Explain different types of self contained sub query?

0 Answers  

---

Tell me the phases a transaction has to undergo?

0 Answers  

---

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

---

Diffrences between sql server 2000 vs 2005

2 Answers   Thomson Reuters,

---

What is nolock hint in sql server 2008

0 Answers   HCL,

---

how many instance use in sql server 2005

4 Answers   EFI, HCL,

---

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

---