This would be the case if there was a very large number of changes. Since it records all of the changes.

I have not build something with all of these features, but having built a multiple word search, I parsed the input string into each of the words and loaded those...

You are correct, I made the assumption that the data that you are searching on would be non-NULLable and should have stated that.

There is not a simple solution that I know of. The only way that I know of to get rid of the old collation is to bcp all of your...

I cannot answer your question directly, but I think that the standard time-out that VB.NET will wait is 30 seconds. Have you tried starting wth setting your WHERE clause to...

If I am understanding your question, the answer is no. If you create a single back-up and then perform differential (or some other change method), each day for a month...

I usually like to go one step further so that if you have a lot of search parameters that are optional you can speed up the search, but not searching...

Frank is right of course, you cannot do this. However, when presented with this problem, I have used the following solution in the past. First create a table with all...