WayneS (9/25/2009)

---

I think Charles said it the best here... "Trust, but verify". If you trust the source (like Grant mentioned), then the verify process can be abbreviated. And if you...

Jack Corbett (9/25/2009)

---

I'm basically with Grant on this one. If I know the source and I know that they are conscientious about testing I'll usually use it, although even...

David.

OK. Like I said "almost always". Are you always needing the % at the end of the string? If so then I would try ranging. (WHERE...

I would have thought the the word LIKE would have tipped things off. I thought that LIKE almost always performed a table scan. Nobody asked about how many...

I think that I'm working for them still.

Well, actually there have been many times that a customer has taken weeks to review a proposal. Then upon signing it act...

We've used MySQL for some intense projects in the past. The problems that we encountered tended not to be with MySQL itself. I had queries that choked in...

Good Morning Steve....

So we don't have all the details, but:

If the tables were moved to a new database and only data that is seldom updated is in the original database then a...

Good work! There have been so many times that I wanted to ...

I noticed two things:

(1) Peter is the new Kenny. Remember "South Park"? ^{[citation needed]} In...

GilaMonster (8/7/2009)

---

Charles Kincaid (8/7/2009)

---

Rats! Thanks. I had seen a number of articles and posts showing the lovely check box. :pinch: It would have been so nice...

GilaMonster (8/7/2009)

---

The fact that it's not in the GUI doesn't mean it's not an available feature. 2005 has the copy_only feature, but it's missing from the dialog and so can...

None of my 2005 SSMS installs have the magic check box. Not even recent Express instsalls. What...

Glen Moffitt (8/7/2009)

---

You don't have to detach the database to delete the log file, just shut down the sql server service. Then the log file is like any other...

The thing about these "loyalty schemes" is that the converse is just as bad. I use a technology provider that I endorse highly. Every aspect of their service...

Be very cautious of the "transposing digits" in the phone number trick. For those outside the U.S. the country has many "area codes". Each state has one or...