Is there any reason you don't want to use a job or jobs for this? They can be fired off automatically, as well as manually, even from Query Analyzer or...

If you mean for working with LIKE, then ...

SET @ParameterName = '%' + @ParameterName + '%'

Of course if you drop the indexes altogether, 3 of the 4 tests should be slightly faster than with the indexes (the second won't be, as the columns are covered)....

You mean like this?

Col1 = Substring(MainColumn,1,250)

,Col2 = Substring(MainColumn,251,250)

,Col3 = Substring(MainColumn,501,250)

,Col4 = Substring(MainColumn,751,250)

Note, you can use left for the first string, but I used Substring to be consistent.

Alex's method will probably work for you, as it's the other timeout that usually is behind this, while you've set the first one already.

If not, you might try setting trace flag...

For the future, can I recommend you look into a different method?

I typically use a lookup table for e-mail addresses, where you have the group title in a column, and...

That field holds a bunch of bits that each denote some piece of information, and they're using the bitwise AND ( & ) with the hex value of "8" to...

Lynn, don't take the bait, as we both know that he knows that we're referring to tolerances. If a scale has a tolerance of 0.1 lbs, and I put a...

rlively, while I'm no longer debating with Sergiy in this thread, as we've already gone over every argument he's ever made, and I've stated that I'm going to stick with...

"It left me wondering though, is there a "right" or "efficient" way to accomplish this? Some way of calculating/generating the sequence numbers as the data is created?"

Since SQL Server is...

The reason you can't use "Type" in your GROUP BY is that "Type" is an alias in your case, and the logical query processing order in SQL dictates that the GROUP BY...

rlively, while I'd still recommend you read the earlier thread, if you see any claims that you doubt, from anyone on either side of this debate, you should ask for verification....

We're actually quite aware that his main argument hinges on the imprecision of numbers, and he is even partially correct, in that they often are, but he's wrong when it...

Since the number of Val and Status columns is dynamic, my first inclination is to tell you that it will take dynamic SQL (if it were fixed, you could do a...

If for some reason you absolutely can't make it a datetime datatype, you should use michaela's suggestion earlier and turn off the sort on the combobox. I understand that you...