wycareersterThet's really nice. And what am I looking for?
ML
Showing posts with label engine. Show all posts
Showing posts with label engine. Show all posts
Wednesday, March 21, 2012
Sunday, February 26, 2012
fulltext statistics
Hi all,
Is it possible to get statistics of any sort from the full text engine?
My understanding is SQL Server treats the the fulltext engine as a remote
server and performs distributed queries against it via oledb. AFAIK, oledb
has optional interfaces to obtain stats (cardinality, distribution) which the
fulltext engine presumably supports since it comes up with reasonable
estimates in estimated query plans involving containstable.
So using an estimated plan is one way to get cardinality estimates for a
particular query, but I'm wondering if there's a more direct approach -- e.g.
I'd really like to be able to just get a histogram of terms. Perhaps it's
possible to connect directly to the full text engine via oledb? If so, what
would the connection string look like? or...?
Thanks for any ideas.
-Geoff
This is supposed to ship in SQL 2008.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Geoff Chappell" <GeoffChappell@.discussions.microsoft.com> wrote in message
news:95516FF5-7316-437D-9278-0463823A028B@.microsoft.com...
> Hi all,
> Is it possible to get statistics of any sort from the full text engine?
> My understanding is SQL Server treats the the fulltext engine as a remote
> server and performs distributed queries against it via oledb. AFAIK, oledb
> has optional interfaces to obtain stats (cardinality, distribution) which
> the
> fulltext engine presumably supports since it comes up with reasonable
> estimates in estimated query plans involving containstable.
> So using an estimated plan is one way to get cardinality estimates for a
> particular query, but I'm wondering if there's a more direct approach --
> e.g.
> I'd really like to be able to just get a histogram of terms. Perhaps it's
> possible to connect directly to the full text engine via oledb? If so,
> what
> would the connection string look like? or...?
> Thanks for any ideas.
> -Geoff
>
>
>
Is it possible to get statistics of any sort from the full text engine?
My understanding is SQL Server treats the the fulltext engine as a remote
server and performs distributed queries against it via oledb. AFAIK, oledb
has optional interfaces to obtain stats (cardinality, distribution) which the
fulltext engine presumably supports since it comes up with reasonable
estimates in estimated query plans involving containstable.
So using an estimated plan is one way to get cardinality estimates for a
particular query, but I'm wondering if there's a more direct approach -- e.g.
I'd really like to be able to just get a histogram of terms. Perhaps it's
possible to connect directly to the full text engine via oledb? If so, what
would the connection string look like? or...?
Thanks for any ideas.
-Geoff
This is supposed to ship in SQL 2008.
http://www.zetainteractive.com - Shift Happens!
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Geoff Chappell" <GeoffChappell@.discussions.microsoft.com> wrote in message
news:95516FF5-7316-437D-9278-0463823A028B@.microsoft.com...
> Hi all,
> Is it possible to get statistics of any sort from the full text engine?
> My understanding is SQL Server treats the the fulltext engine as a remote
> server and performs distributed queries against it via oledb. AFAIK, oledb
> has optional interfaces to obtain stats (cardinality, distribution) which
> the
> fulltext engine presumably supports since it comes up with reasonable
> estimates in estimated query plans involving containstable.
> So using an estimated plan is one way to get cardinality estimates for a
> particular query, but I'm wondering if there's a more direct approach --
> e.g.
> I'd really like to be able to just get a histogram of terms. Perhaps it's
> possible to connect directly to the full text engine via oledb? If so,
> what
> would the connection string look like? or...?
> Thanks for any ideas.
> -Geoff
>
>
>
Friday, February 24, 2012
Full-text search engine on SQL Server 2000
I have tried install Microsoft full-text search engine on SQL Server
2000 (Developer version). The operating system is XP Pro SP2,
with .net framework 2.0. With every variation I have tried to install
it I get:
"Installation of Microsoft Full-Text Search Engine Package Failed
(-2147220991) 0x80040201. An event was unable to invoke any of the
subscribers."
Any ideas?
Is this relevant?
http://www.kbalertz.com/Feedback_926997.aspx
"Denzyl" <daryl@.partridgesoftwaresolutions.com> wrote in message
news:1178736692.825863.109950@.n59g2000hsh.googlegr oups.com...
>I have tried install Microsoft full-text search engine on SQL Server
> 2000 (Developer version). The operating system is XP Pro SP2,
> with .net framework 2.0. With every variation I have tried to install
> it I get:
> "Installation of Microsoft Full-Text Search Engine Package Failed
> (-2147220991) 0x80040201. An event was unable to invoke any of the
> subscribers."
> Any ideas?
>
|||On 9 May, 20:42, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> Is this relevant?
> http://www.kbalertz.com/Feedback_926997.aspx
> "Denzyl" <d...@.partridgesoftwaresolutions.com> wrote in message
> news:1178736692.825863.109950@.n59g2000hsh.googlegr oups.com...
>
>
>
> - Show quoted text -
Thanks Hilary. Looked into this and appears that the original error
occurs whether .net framework 2 is installed or not.
2000 (Developer version). The operating system is XP Pro SP2,
with .net framework 2.0. With every variation I have tried to install
it I get:
"Installation of Microsoft Full-Text Search Engine Package Failed
(-2147220991) 0x80040201. An event was unable to invoke any of the
subscribers."
Any ideas?
Is this relevant?
http://www.kbalertz.com/Feedback_926997.aspx
"Denzyl" <daryl@.partridgesoftwaresolutions.com> wrote in message
news:1178736692.825863.109950@.n59g2000hsh.googlegr oups.com...
>I have tried install Microsoft full-text search engine on SQL Server
> 2000 (Developer version). The operating system is XP Pro SP2,
> with .net framework 2.0. With every variation I have tried to install
> it I get:
> "Installation of Microsoft Full-Text Search Engine Package Failed
> (-2147220991) 0x80040201. An event was unable to invoke any of the
> subscribers."
> Any ideas?
>
|||On 9 May, 20:42, "Hilary Cotter" <hilary.cot...@.gmail.com> wrote:
> Is this relevant?
> http://www.kbalertz.com/Feedback_926997.aspx
> "Denzyl" <d...@.partridgesoftwaresolutions.com> wrote in message
> news:1178736692.825863.109950@.n59g2000hsh.googlegr oups.com...
>
>
>
> - Show quoted text -
Thanks Hilary. Looked into this and appears that the original error
occurs whether .net framework 2 is installed or not.
Subscribe to:
Posts (Atom)