Some good points raised here. I have one more opinion on this though. If you need to rename database often enough to have to automate that process, it's...

cy (9/2/2008)

---

Very good point. This is helpful especially if you have restore...

And here I thought that the omission was intended to BE the first blopper. 😉

Our special broadcast tonight at midnight is going to be something spectacular. Don't fail to...

That's a good document. Seems pro Oracle, even more so when you consider that they make Oracle add-ons. There is no TCO study, no total average up time....

Great article Jeff. Keep 'em coming.

Further, Grant's book explodes the myth that LIKE always forces a table scan.

kathyoshea (8/15/2008)

---

I've never really gotten a handle on execution plans and was hoping to use the code in the article to understand them a bit more. However, the code in...

The problem with "All Cretans are liars" is that we now know that liars tell truth in order...

Re-read the original article. Jeff points out the problem with using the index and points out that you should use order by instead.

I was not going to weigh in on this, but since no one is looking: :w00t:

Our new net admin is putting out a policy statement that says that the company...

Great article. I'm almost surprised that this has not drawn more fire ... er ... posts. It's early in the US though.

The cost of MySQL is great. ...

You think I'm bad, the guy who designed the test found a bug in VS 2008. The way the code is broken throws Intellisense off. It makes wrong...

Thanks for the good thought, Alvin. We run SQL Express on that laptop. We have crippled the chip set for the wireless card, the LAN card, and the...

If you created a table in Model on restart it would be in TempDB and in the state created. Am I reading correctly here? Then:

(1) I have a...

Dex (8/4/2008)

---

Code Reuse doesn't work: Of course it does. Arguing that you would have to rewrite large sections of code because you don't understand it is just laughable. If this...