When I perform a search through our application where the name has a space
in it, the search takes much longer to execute than if the name did not have
a space in it (ex: martin square).

The Name field is indexed.

Is there anything we can do to make this faster?

-Bill



MS Sql Server LazyDBA home page