Another .sig-worthy quote.

Brandie holds out virtual chocolate-covered biltong. "I hear it makes everything better."

Wait a sec... Read that page carefully.

Brad states:

Non-sargable search arguments in the WHERE clause, such as "IS NULL", "<>", "!=", "!>", "!<", "NOT", "NOT EXISTS", "NOT IN", "NOT LIKE", and...

Brad's article is written in 2007. So I'd think he'd have known about any SQL 2005 stuff.

He does add that covering indexes might explain a seek instead of a...

This might explain the difference between what you're saying and what you're seeing.

Brad

---

...not every WHERE clause that has a non-sargable expression in it is doomed to a table/index scan. If...

Steve Jones - SSC Editor (10/12/2010)

---

I have found that single rooms are the best earplugs...

Congrats indeed! That's a wonderful milestone.

Only 82 more years to go. @=)

Rutabaga

liewsb (10/11/2010)

---

Hi Gail,

I will carry out to shrink the log file this morning, here are the steps to carry out:

1. Change the Database recovery model to simple.

2. Execuate checkpoint command;

3....

You're welcome. Let us know if you need anything else.

Hey! I...

If you're going to use the backup on another server, rather than the server the backup was saved to, I recommend moving the backup file *before* converting it to a...

Then I suggest doing more of a normalized set up with all the "main" part numbers in one table and all the alternate part numbers in a reference table.

Just an...

I accidently hit enter on this post.. wish I could have deleted it.

Yikes. You're trying to eliminate cascading values? That's not nearly as easy as you presented it and changes both answers you've received on this thread.

Leaning towards Celko on this...