Thanks for the response. I had a really tough time summarizing my issue and now that I read over it, I can see I wasn't really clear about my specific...

PaulB-TheOneAndOnly (3/11/2011)

---

Out of curiosity, may I ask what kind of issues?

Backup/Restore and Detach/Attach methods are not supposed to change collation on target system e.g. collation remains the same as the...

This is the answer I was anticipating. I posted this same question on about 5 different sites and either no one replied or no one knew. And I really tried...

I agree. You should never assume that any optimization has actually optimized anything until you test it. Testing L2S is a pain in the *** because you basically need to...

Well the find query that I am currently optimizing is paged so it returns at most 20 rows on a 2.5million row table. So I guess by using paging I...

Thanks so much for the link. That was a great introduction to indexes, something I sorely needed!

I do have a couple questions however. The 3rd part on non-clustered indexes and...

The @Value is coming from an ASP.NET business object. So should I be doing a search and replace for the _ character and using the ESCAPE thing? Seems like there...

OIC the parameter is still a parameter in the query. I was thinking for some reason the @p_Value would be replaced inline with the value but it just works as...

Okay still no luck.

My query now looks something like this:

DECLARE @sql nvarchar(MAX),

@OP nvarchar(9),

@Name nvarchar(128),

...

Thanks for the quick replies!

So I thought the point of the parametrization was to avoid using string concatenation?

But it only works in certain situations? That's odd.

I suppose I could...