I need to search many fields in multiple tables using Like %'$var'% in my queries, but my hosting provider blocked my database because it overloaded their server. Any suggestions? I cant afford a dedicated server.

Hello,

I have used mysql directly, however one practice that my company uses with SQLServer is to use Nolocks on tables.

The syntax for Sqlserver is "select * from TableA (Nolock) ..."

Also if you are seraching a field in my different tables you could insert the data from all the tables into a temp table and then do a serach only on the temp table.