No reflection on the article, which is thorough & well written, but I went from thinking that natively compiled sprocs sounded great to wondering in what circumstances I'd ever be...

...oops just realised one further thing: my version doesn't work correctly where there are trailing spaces, because the LEN function ignores them.

This fixes that by adding a character to the...

This does have a slight flaw:

Any spaces in the original string get replaced with the character you're trying to trim.

E.g. The result of

Print [dbo].[TrimLeftChar]( '.', '...will i am')

will...

Dave Ramsey would frame the question this way: "Given your current financial circumstances, would spend $100,000 of your savings to go on on a space shuttle ride?".

I'd personally take the...

There's also the aspect that while Armadillo Aerospace seem an interesting outfit they don't seem particularly close to having the capability to launch manned sub-orbital flights. Given the choice between...

Of all the databases I'd have expected to have the right constraints defined, this would have been top of the list. You'll be telling us it's all done...

Thanks Andy for an interesting article, like some of the others I'm not sure I can see myself going down the test-driven route in the same way, but it's good...

bstauffer (6/16/2009)

---

I got turned off by the apparent lack of understanding of how to use "IF EXISTS". Do you really think you need to do concatenation there??? You...

From the point of view of someone who's seen a lot of hype about cloud computing but knows little of the substance...

I'm very cynical about the whole thing. I...

JoeA (2/6/2009)Is it possible that your Ctrl+Shift+M is being caught by another program?

I had this issue with a similar key sequence where an HP diagnostic (or update manager?) was catching...

Interesting - I'm on the same version. The other shortcut combis all work ok though. I'd just assumed templates had been forgotten. hmmm...

One of the annoyances of SSMS 2008 is that Ctrl-Shift-M no longer works.

If you've got to let it idle to charge now and then, what's the point of having a hybrid?

Can you imagine a world where tens of thousands Prius's are in...

I was driving downhill over the weekend at 40 in 5th gear and reset the mpg meter. For the next quarter of a mile, the it showed 99.9mpg. OK,...

I think there's a far more interesting story to be told here about just how such a design was arrived at!

I've made my fair share of design mistakes, but I...