Boosting up Fuzzy Lookups performance

Hello there,

Is there any way to increase the speed of search while performing fuzzy lookups against a 300,000 row Table ?

include a index for the column

Boosting SQL Server Priority on Windows

If I dedicate a Win 2003 box to only SQL Server, does it make sense to boost
sql server priority on the box?
--
JohnIf it is the only thing on the box then you shouldn't need it. I have seen
this setting hurt more than help in most cases. I would leave it at the
default unless you know for sure you need it.
--
Andrew J. Kelly SQL MVP
"JT" <Jthayer@.online.nospam> wrote in message
news:1FDFA76C-D8C8-4C48-BDD3-C8165DC0752D@.microsoft.com...
> If I dedicate a Win 2003 box to only SQL Server, does it make sense to
> boost
> sql server priority on the box?
> --
> John

Boosting SQL Server Priority on Windows

If I dedicate a Win 2003 box to only SQL Server, does it make sense to boost
sql server priority on the box?
John
If it is the only thing on the box then you shouldn't need it. I have seen
this setting hurt more than help in most cases. I would leave it at the
default unless you know for sure you need it.
Andrew J. Kelly SQL MVP
"JT" <Jthayer@.online.nospam> wrote in message
news:1FDFA76C-D8C8-4C48-BDD3-C8165DC0752D@.microsoft.com...
> If I dedicate a Win 2003 box to only SQL Server, does it make sense to
> boost
> sql server priority on the box?
> --
> John

Boosting SQL Server Priority on Windows

If I dedicate a Win 2003 box to only SQL Server, does it make sense to boost
sql server priority on the box?
--
JohnIf it is the only thing on the box then you shouldn't need it. I have seen
this setting hurt more than help in most cases. I would leave it at the
default unless you know for sure you need it.
Andrew J. Kelly SQL MVP
"JT" <Jthayer@.online.nospam> wrote in message
news:1FDFA76C-D8C8-4C48-BDD3-C8165DC0752D@.microsoft.com...
> If I dedicate a Win 2003 box to only SQL Server, does it make sense to
> boost
> sql server priority on the box?
> --
> John

boosting

Does SQLServe 2005 have support for boosting or bagging?

SQL Server 2005 does not support bagging or boosting. You can however create multiple models on the server and use client code or stored procedures to implement the bagging/boosting logic.

|||thank you.