I use a set of CLR based functions to detect injection. Helps that its done right at the database level, with no possible client or network hacking possibilities.

Handwritten, they...

Question Requirements!

Yeah, I know it sounds crazy that I want to "avoid" optimization. But if the data and tables and query have not changed from one day to the next, running...

My situtation is I have literally 100k queries that need to execute every night. Currently the SQL is in a field in table. A CLR iterates the table executing each...

Sharepoint Search service uses SQL Server FTS. Based on results listed

http://technet.microsoft.com/en-us/library/cc262574(office.12).aspx

you should be able to do 20 requests per second on a 15 million item library with one...

Todd,

This is why FTS is hard. splitting some text by whitespace, building a list of "words" and pointers back to the text isn't difficult.

Knowing when and how to group a...

Thanks antonio. You've given some great info.

Currently I'm using dynamic SQL, but intended to convert it one day. Now I know it can be done. Awesome!!!

Your use of FTS...

Actually, I wrote of this just a week ago. The Contains function is often not sufficient for end user search. It doesn't handle misspellings, suggested search, implied "AND", and crashes...

Does this make sense. Why would you not use the built in full text search. Its good enough to power sharepoints document search. its built in from 2005 on and...

I would argue these points:

1) We do database here, not front ends. This is a SQL forum.

2) We work in Microsoft. We get paid to do what we do if...

Proprietary? Open source? I guess that would depend on what we agree is needed. There isn't really much out there in either at present, there could be commercial market for...

there's nothing helpful. it crashes when using on non-data access CLRs, for example:

Public Shared Function IsValidZip(ByVal Zip As SqlString) As SqlBoolean

...

The problem occured without the console app running. Also, I was able to recycle the pool with no effect--in fact I restarted IIS entirely without effect.

Nothing short of dropping and...

Well. The problem usually (but not always) happens when a stand alone app (vb.net console) is quite active. The app does not depend on any CLRs.

All the CLRs that access...

As the problem happened again, i went through each CLR function, drop and added.

None of the individual functions were the issue, only when I completely drop the assembly and reattach...