Ticks me off that he tells the poor OP to stop programming when the OP clearly, in one line right above Celko's response, indicates that this...

liewsb (10/13/2010)

---

After shrinking, the file size is 15,768,960KB. The following is the output obtained:

DbId FileId CurrentSize MinimumSize UsedPages EstimatedPages

------ ----------- -----------...

Sorry, Jason. Call for sponsors is closed.

However, on future SQL Saturday events, just click the sponsors page and you...

Oh, and before I forget... Have the stats on the table been updated at all since inception?

And just how long have all your services been running?

I don't recommend restarting...

Is the query forcing recompiles? Or forcing the use of a specific execution plan each time (maybe the wrong execution plan)?

This could still be a hardware or network issue. How...

CirquedeSQLeil (10/12/2010)

---

Brandie Tarvin (10/12/2010)

---

CirquedeSQLeil (10/12/2010)

---

GilaMonster (10/12/2010)

---

3) Stabbing your team members in the back (figuratively) is not a good way of advancing your career. It doesn't take long for people to...

CirquedeSQLeil (10/12/2010)

---

GilaMonster (10/12/2010)

---

3) Stabbing your team members in the back (figuratively) is not a good way of advancing your career. It doesn't take long for people to figure out what's...

You missed his earlier reference to it: "Really Bl00dy Fast"

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. @=)