GilaMonster (11/4/2009)

---

There is no one, single, always right answer to your question. Without knowing the queries that run against that table,...

Lowell (11/3/2009)

---

Gail's "it depends" answer is spot on...it depends on how your data gets accessed; indexes help find the data faster.

ok 10 million records, but which columns are actually used...

GilaMonster (11/3/2009)

---

As I said, it depends. It depends purely on the...

sorry, may be i explain my question badly.I have a table with 10 million records, and i created Separate index for each index-needed columns . my question is :

its better...

Paul White (9/9/2009)

---

In Management Studio, expand your database name, then Storage. There you will find full-text stop lists.

See Stop...

Paul White (9/9/2009)

---

In Management Studio, expand your database name, then Storage. There you will find full-text stop lists.

See Stop...

benyos (9/8/2009)

---

Numbers are possiblr to be saught by configuring noise.dat file on your server and re-indexing whole content.

Special chars, however, require you to write a new language analyzer... See MSDN...

benyos (9/8/2009)

---

Numbers are possiblr to be saught by configuring noise.dat file on your server and re-indexing whole content.

Special chars, however, require you to write a new language analyzer... See MSDN...

select *

from tblDocument

where contains(docNo,'"/abc 123 \*"')

if u want use Remote desktop u can use this :

mstsc -v [destination] -console

thanx for your response Chirag 🙂

locking may be the problem use fast firs row to solve

(delete from tb with (fastfirstrow) where ....)

if run this command is critical, set commandTimeOut = 0 (unlimit)