Option B is your best bet. The only issue with it is that you can eventually end up with 128 subversions of that search proc. Assuming it stops...

matthew.peters (12/7/2011)

---

Hey Guys

I have an issue where an application is running a few different select queries with 'like' operators on a large table in the datebase. These queries in turn...

deanroush (12/16/2011)

---

I tried but could not see your plan for some reason and also therefore cannot determine how many rows you are scanning. However, just wondering if you can...

SQL Kiwi (12/16/2011)

---

Clearly I will need to work harder at surprising you in...

This is for 2007, but it hasn't really changed since 97.

Just add it in the query (datasource).

I've had issues in the past (2000, 2003). Not sure if it was me or access but that solved it.

Check what my script does. It can be converted to 2000 with a little work.

Doesn't work on 2000.

The backup size history is perfect for that. You just have to not delete it!

Here's a beta script I built :

IF OBJECT_ID('tempdb..#dbs') > 0

...

SQL Kiwi (12/16/2011)

---

An email distribution list. I saw the change on Connect before coming here, or looking at the DL, and already added a comment...

You data growth in the datafiles or the data files themselves growth?

GilaMonster (12/16/2011)

---

Ninja's_RGR'us (12/16/2011)

---

As of today, closed as won't fix!!!

You know, it's not like it causes corruption and kills your prod db or anything that serious :sick:

Time...

As of today, closed as won't fix!!!

You know, it's not like it causes corruption and kills your prod db or anything that serious :sick:

Time to speak...

As of today, closed as won't fix!!!

You know, it's not like it causes corruption and kills your prod db or anything that serious :sick:

Time to speak...

Few things are not optimizable at all.

With a covering index, '%abc%' would still SCAN, but it would likely be a faster scan than a full table scan.

'abc%' = possible seek*

'abc'...