Full Text Searching

I want to use full text indexing. I have read you need to leave 50MB spare
on the server. Is this per index,database or instance of SQL Server and does
it increase with the size of the table or is just a static amount virtual
memory to be put aside. Regards.Where did you read? Could you show us a link? Is that RAM or hard disk
space?
Full-Text search service, indexes the data in your tables, in its own index
files outside SQL Server. So, the bigger your tables, the bigger the full
text catalog file size.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Chris Kennedy" <nospam@.microsoft.com> wrote in message
news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
I want to use full text indexing. I have read you need to leave 50MB spare
on the server. Is this per index,database or instance of SQL Server and does
it increase with the size of the table or is just a static amount virtual
memory to be put aside. Regards.|||I read it in Inside SQL Server. I may have got it wrong. I read 5O MB plus
about 30% of the table size.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:#FAAcBs3DHA.484@.TK2MSFTNGP10.phx.gbl...
| Where did you read? Could you show us a link? Is that RAM or hard disk
| space?
|
| Full-Text search service, indexes the data in your tables, in its own
index
| files outside SQL Server. So, the bigger your tables, the bigger the full
| text catalog file size.
| --
| HTH,
| Vyas, MVP (SQL Server)
| http://vyaskn.tripod.com/
| Is .NET important for a database professional?
| http://vyaskn.tripod.com/poll.htm
|
|
|
|
| "Chris Kennedy" <nospam@.microsoft.com> wrote in message
| news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
| I want to use full text indexing. I have read you need to leave 50MB spare
| on the server. Is this per index,database or instance of SQL Server and
does
| it increase with the size of the table or is just a static amount virtual
| memory to be put aside. Regards.
|
|
|
||||Chris, you are referencing Kalen's "Inside SQL Server 2000" book on page583
as she states that at least 50MB of hard drive space must be available to
create a FT Catalog on the disk drive. I don't have disk small enough to
test this <g>, but if you are FT Indexing via the FT Wizard and placing the
FT Catalog on a disk drive of less that 50MB, you will get an error.
Although, I found no reference to 30% of anything. Could you clarify more
what your concerns are?
Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext
Regards,
John
"Chris Kennedy" <nospam@.microsoft.com> wrote in message
news:#$7LI#33DHA.2544@.TK2MSFTNGP10.phx.gbl...

quote:

---

> I read it in Inside SQL Server. I may have got it wrong. I read 5O MB plus
> about 30% of the table size.
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:#FAAcBs3DHA.484@.TK2MSFTNGP10.phx.gbl...
> | Where did you read? Could you show us a link? Is that RAM or hard disk
> | space?
> |
> | Full-Text search service, indexes the data in your tables, in its own
> index
> | files outside SQL Server. So, the bigger your tables, the bigger the

---

full

quote:

---

> | text catalog file size.
> | --
> | HTH,
> | Vyas, MVP (SQL Server)
> | http://vyaskn.tripod.com/
> | Is .NET important for a database professional?
> | http://vyaskn.tripod.com/poll.htm
> |
> |
> |
> |
> | "Chris Kennedy" <nospam@.microsoft.com> wrote in message
> | news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
> | I want to use full text indexing. I have read you need to leave 50MB

---

spare

quote:

---

> | on the server. Is this per index,database or instance of SQL Server and
> does
> | it increase with the size of the table or is just a static amount

---

virtual

quote:

---

> | memory to be put aside. Regards.
> |
> |
> |
> |
>

---

|||What amount of space will a full text index take in e. g. a 10 MB table.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OBnfOx53DHA.2460@.TK2MSFTNGP10.phx.gbl...
| Chris, you are referencing Kalen's "Inside SQL Server 2000" book on
page583
| as she states that at least 50MB of hard drive space must be available to
| create a FT Catalog on the disk drive. I don't have disk small enough to
| test this <g>, but if you are FT Indexing via the FT Wizard and placing
the
| FT Catalog on a disk drive of less that 50MB, you will get an error.
| Although, I found no reference to 30% of anything. Could you clarify more
| what your concerns are?
|
| Note, you can also post FTS related questions to the newsgroup:
| microsoft.public.sqlserver.fulltext
| Regards,
| John
|
|
|
| "Chris Kennedy" <nospam@.microsoft.com> wrote in message
| news:#$7LI#33DHA.2544@.TK2MSFTNGP10.phx.gbl...
| > I read it in Inside SQL Server. I may have got it wrong. I read 5O MB
plus
| > about 30% of the table size.
| >
| > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
| > news:#FAAcBs3DHA.484@.TK2MSFTNGP10.phx.gbl...
| > | Where did you read? Could you show us a link? Is that RAM or hard disk
| > | space?
| > |
| > | Full-Text search service, indexes the data in your tables, in its own
| > index
| > | files outside SQL Server. So, the bigger your tables, the bigger the
| full
| > | text catalog file size.
| > | --
| > | HTH,
| > | Vyas, MVP (SQL Server)
| > | http://vyaskn.tripod.com/
| > | Is .NET important for a database professional?
| > | http://vyaskn.tripod.com/poll.htm
| > |
| > |
| > |
| > |
| > | "Chris Kennedy" <nospam@.microsoft.com> wrote in message
| > | news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
| > | I want to use full text indexing. I have read you need to leave 50MB
| spare
| > | on the server. Is this per index,database or instance of SQL Server
and
| > does
| > | it increase with the size of the table or is just a static amount
| virtual
| > | memory to be put aside. Regards.
| > |
| > |
| > |
| > |
| >
| >
|
|

Full Text Searching

I want to use full text indexing. I have read you need to leave 50MB spare
on the server. Is this per index,database or instance of SQL Server and does
it increase with the size of the table or is just a static amount virtual
memory to be put aside. Regards.Where did you read? Could you show us a link? Is that RAM or hard disk
space?
Full-Text search service, indexes the data in your tables, in its own index
files outside SQL Server. So, the bigger your tables, the bigger the full
text catalog file size.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Chris Kennedy" <nospam@.microsoft.com> wrote in message
news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
I want to use full text indexing. I have read you need to leave 50MB spare
on the server. Is this per index,database or instance of SQL Server and does
it increase with the size of the table or is just a static amount virtual
memory to be put aside. Regards.|||I read it in Inside SQL Server. I may have got it wrong. I read 5O MB plus
about 30% of the table size.
"Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
news:#FAAcBs3DHA.484@.TK2MSFTNGP10.phx.gbl...
| Where did you read? Could you show us a link? Is that RAM or hard disk
| space?
|
| Full-Text search service, indexes the data in your tables, in its own
index
| files outside SQL Server. So, the bigger your tables, the bigger the full
| text catalog file size.
| --
| HTH,
| Vyas, MVP (SQL Server)
| http://vyaskn.tripod.com/
| Is .NET important for a database professional?
| http://vyaskn.tripod.com/poll.htm
|
|
|
|
| "Chris Kennedy" <nospam@.microsoft.com> wrote in message
| news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
| I want to use full text indexing. I have read you need to leave 50MB spare
| on the server. Is this per index,database or instance of SQL Server and
does
| it increase with the size of the table or is just a static amount virtual
| memory to be put aside. Regards.
|
|
|
||||Chris, you are referencing Kalen's "Inside SQL Server 2000" book on page583
as she states that at least 50MB of hard drive space must be available to
create a FT Catalog on the disk drive. I don't have disk small enough to
test this <g>, but if you are FT Indexing via the FT Wizard and placing the
FT Catalog on a disk drive of less that 50MB, you will get an error.
Although, I found no reference to 30% of anything. Could you clarify more
what your concerns are?
Note, you can also post FTS related questions to the newsgroup:
microsoft.public.sqlserver.fulltext
Regards,
John
"Chris Kennedy" <nospam@.microsoft.com> wrote in message
news:#$7LI#33DHA.2544@.TK2MSFTNGP10.phx.gbl...
> I read it in Inside SQL Server. I may have got it wrong. I read 5O MB plus
> about 30% of the table size.
> "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
> news:#FAAcBs3DHA.484@.TK2MSFTNGP10.phx.gbl...
> | Where did you read? Could you show us a link? Is that RAM or hard disk
> | space?
> |
> | Full-Text search service, indexes the data in your tables, in its own
> index
> | files outside SQL Server. So, the bigger your tables, the bigger the
full
> | text catalog file size.
> | --
> | HTH,
> | Vyas, MVP (SQL Server)
> | http://vyaskn.tripod.com/
> | Is .NET important for a database professional?
> | http://vyaskn.tripod.com/poll.htm
> |
> |
> |
> |
> | "Chris Kennedy" <nospam@.microsoft.com> wrote in message
> | news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
> | I want to use full text indexing. I have read you need to leave 50MB
spare
> | on the server. Is this per index,database or instance of SQL Server and
> does
> | it increase with the size of the table or is just a static amount
virtual
> | memory to be put aside. Regards.
> |
> |
> |
> |
>|||What amount of space will a full text index take in e. g. a 10 MB table.
"John Kane" <jt-kane@.comcast.net> wrote in message
news:OBnfOx53DHA.2460@.TK2MSFTNGP10.phx.gbl...
| Chris, you are referencing Kalen's "Inside SQL Server 2000" book on
page583
| as she states that at least 50MB of hard drive space must be available to
| create a FT Catalog on the disk drive. I don't have disk small enough to
| test this <g>, but if you are FT Indexing via the FT Wizard and placing
the
| FT Catalog on a disk drive of less that 50MB, you will get an error.
| Although, I found no reference to 30% of anything. Could you clarify more
| what your concerns are?
|
| Note, you can also post FTS related questions to the newsgroup:
| microsoft.public.sqlserver.fulltext
| Regards,
| John
|
|
|
| "Chris Kennedy" <nospam@.microsoft.com> wrote in message
| news:#$7LI#33DHA.2544@.TK2MSFTNGP10.phx.gbl...
| > I read it in Inside SQL Server. I may have got it wrong. I read 5O MB
plus
| > about 30% of the table size.
| >
| > "Narayana Vyas Kondreddi" <answer_me@.hotmail.com> wrote in message
| > news:#FAAcBs3DHA.484@.TK2MSFTNGP10.phx.gbl...
| > | Where did you read? Could you show us a link? Is that RAM or hard disk
| > | space?
| > |
| > | Full-Text search service, indexes the data in your tables, in its own
| > index
| > | files outside SQL Server. So, the bigger your tables, the bigger the
| full
| > | text catalog file size.
| > | --
| > | HTH,
| > | Vyas, MVP (SQL Server)
| > | http://vyaskn.tripod.com/
| > | Is .NET important for a database professional?
| > | http://vyaskn.tripod.com/poll.htm
| > |
| > |
| > |
| > |
| > | "Chris Kennedy" <nospam@.microsoft.com> wrote in message
| > | news:uzfFfzq3DHA.2888@.tk2msftngp13.phx.gbl...
| > | I want to use full text indexing. I have read you need to leave 50MB
| spare
| > | on the server. Is this per index,database or instance of SQL Server
and
| > does
| > | it increase with the size of the table or is just a static amount
| virtual
| > | memory to be put aside. Regards.
| > |
| > |
| > |
| > |
| >
| >
|
|

Full Text Search: percentage match

I need to add a percentage "perfect match" for my search-action, for instance 50% perfect match if only one of the 2 searchexpressions were found. Full Text Search seems to perfect for the search-action, but how do I add this percentage to my select?

This may have a simple solution but I do not seem to be able to find it. Any help is greatly appreciated.

Vicky

You need to put each search expression in a different containstable() and aggregate over the union of the containstable results.

|||Thanks for the reply but can you give me a bit more information? How can this help to generate a percentage match for a search?|||

Say you want percentage match on "foo" and "bar".

select foo.[key],(IsNull(foo.fooExist, 0)+IsNull(bar.barExist,0))/ 2.0

from

(

(select [key], 1 as fooExist fromcontainstable(t1,*,'hello')) foo

fullouterjoin

(select [key], 1 as barExist fromcontainstable(t1,*,'bar')) bar

on foo.[key] = bar.[key]

)

|||

Thanks for your example! I'll give it a try.

|||

hey
Can u guide me if possible..
I'm able to create Full text indexing catalogs, populate them etc.. when i login directly from the server using Sql Server Enterprise manager but when I try to use the same login (db owner) remotely from some other machine using SQL Server Enterprise Manager, I see disabled Full-text Service and all full-text features disabled. So how can i populate or create catalogs remotely using sql server enterprise manager.
Thanks

|||Sattva,
See my reply in the http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=816452&SiteID=1&mode=1 thread..

Thanks,
John
SQL Full Text Search Blog
http://jtkane.spaces.live.com/

Full Text Search: percentage match

I need to add a percentage "perfect match" for my search-action, for instance 50% perfect match if only one of the 2 searchexpressions were found. Full Text Search seems to perfect for the search-action, but how do I add this percentage to my select?

This may have a simple solution but I do not seem to be able to find it. Any help is greatly appreciated.

Vicky

You need to put each search expression in a different containstable() and aggregate over the union of the containstable results.

|||Thanks for the reply but can you give me a bit more information? How can this help to generate a percentage match for a search?|||

Say you want percentage match on "foo" and "bar".

select foo.[key], (IsNull(foo.fooExist, 0) + IsNull(bar.barExist,0)) / 2.0

from

(

(select [key], 1 as fooExist from containstable(t1, *, 'hello')) foo

full outer join

(select [key], 1 as barExist from containstable(t1, *, 'bar')) bar

on foo.[key] = bar.[key]

)

|||

Thanks for your example! I'll give it a try.

|||

hey
Can u guide me if possible..
I'm able to create Full text indexing catalogs, populate them etc.. when i login directly from the server using Sql Server Enterprise manager but when I try to use the same login (db owner) remotely from some other machine using SQL Server Enterprise Manager, I see disabled Full-text Service and all full-text features disabled. So how can i populate or create catalogs remotely using sql server enterprise manager.
Thanks

|||Sattva,
See my reply in the http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=816452&SiteID=1&mode=1 thread..

Thanks,
John
SQL Full Text Search Blog
http://jtkane.spaces.live.com/

Full Text Search: Is it working?

I need to add a percentage "perfect match" for my search-action, for instance 50% perfect match if only one of the 2 searchexpressions were found. Full Text Search seems to perfect for the search-action, but how do I add this percentage to my select?

This may have a simple solution but I do not seem to be able to find it. Any help is greatly appreciated.

Vicky

You need to put each search expression in a different containstable() and aggregate over the union of the containstable results.

|||Thanks for the reply but can you give me a bit more information? How can this help to generate a percentage match for a search?|||

Say you want percentage match on "foo" and "bar".

select foo.[key], (IsNull(foo.fooExist, 0) + IsNull(bar.barExist,0)) / 2.0

from

(

(select [key], 1 as fooExist from containstable(t1, *, 'hello')) foo

full outer join

(select [key], 1 as barExist from containstable(t1, *, 'bar')) bar

on foo.[key] = bar.[key]

)

|||

Thanks for your example! I'll give it a try.

|||

hey
Can u guide me if possible..
I'm able to create Full text indexing catalogs, populate them etc.. when i login directly from the server using Sql Server Enterprise manager but when I try to use the same login (db owner) remotely from some other machine using SQL Server Enterprise Manager, I see disabled Full-text Service and all full-text features disabled. So how can i populate or create catalogs remotely using sql server enterprise manager.
Thanks

|||Sattva,
See my reply in the http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=816452&SiteID=1&mode=1 thread..

Thanks,
John
SQL Full Text Search Blog
http://jtkane.spaces.live.com/