There seems to be an issue in regards to ANSI vs Unicode

When the file is viewed as an ANSI encoded file, both chars show

When the file is viewed as an...

I tried that first...didn't work

I researched a bit and found something called a surrogate pair, where if the char number is higher than a certain range, it introduces two chars...

Lesson learned...

I thought by separating the temp table 2 statement in parenthesis, it was separated from the temp table 1 statement, and no alias would be needed...

Won't make that error...

Oh yes the search table and the joined tables have indexes on the columns used for matching.

If applied, wouldn't the transaction cause potential blocking?

Just making sure I know the impact...

Unfortunately, there is no specific pattern to the data being updated or the data being queried so clustering would not work here.

You mentioned a transaction earlier. To clarify, if...

Thanks for the response....

As far as the timing, the actual insert and delete can take a few minutes, depending on the amount of data.

What is your opinion regarding the practice...

Let me clarify...we do not do wildcard searches in the Full Text Index...

I was merely comparing normal wild card searches to Full Text searches...

Sorry for the confusion...

Well, unfortunately, this is a table that has 13 different allowable search parameters, with no requirements i.e. must search A AND B...so users can actually search any of the 13...

Thank you...that is also my opinion...just wanted some more input!!!

Hopefully no more than 8 hours...thanks again!

Thank you Roy for your response...

What about startup? Should there be a certain sequence or will SQL Handle it?

Hi Amit...hope this helps...

Server A serves as a publisher to subscriber Server B, DB 1, which pulls the data

Server B, DB 2 also serves as a publisher to subscribers Server...

yes...in fact, table 2 is our job table.

What would be the impact of running a job on the server every minute? We run a lot of processes, including decrypt...

Oh...one last thing...SQL Server 2005

yes...a friend of mine suggested doing that as we have 3 basic tables to search...Accts, SSN's, and a flat table holding all the rest of the item's data i.e. name,...