I've avoided money as I'm not sure if provides benefits over the numeric types. It also limits me, and I prefer to not be limited. I let the application handle...

The compatibility level determines how the code is interpreted by the server. It allows keywords that did not exist in 2000 (or 7) but do exist in 2005 to still...

If you are on SQL 2000, I'd use GSquared's idea and make sure that you secure the keys well that are used in the DLLs. If you have them protected...

You need to look in the properties for each instance to determine what the memory settings are, not the Windows System Monitor.

This is a belated honeymoon with my lovely wife, so I don't think I'll be doing any work.

I'd love to come over sometime, just not sure I can get the...

Roy Ernest (1/8/2010)

---

On another note, You guys should take a vacation to this tiny island during new year. You will the whole island lit up at 12 mid night with...

I haven't seen GI Joe, but it looks cool. Working through Angels and Demons on most of my runs now, but might try GI Joe after that.

I think you'd have to do something like the ping test listed, writing to a file, to help determine this.

What does the process do exactly in terms of calling sprocs?...

Thanks, Paul.

I added a note to your blog as well. If that's correct, I'll edit the article to make sure people understand. I think the article is a little ambiguous...

If you have databases in simple mode, you do not need log backups. The checkpoints should mark the log as free. I'm not sure why you see this error in...

Doh! It's fixed. I must have made a mistake when I changed the question.

It now shows predicate as the answer. I'll fix points.

the answer is predicate. It has not changed. The change from

"IN"

to

"columnX IN (x, y, z, ...)"

Makes it a predicate.

That's an interesting article (I edited the link to make it hot) and thanks for posting it.

There are lots of "geeks" among the women I know in IT, but those...

That's the trick I've used. The annoyance, however, is likely worth the chance to work at home 😛

I guess opinions can change, but I'd think that you would have a definite opinion right off about someone being worthy of the hall. That's why I'd like to see...