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...

The dates for the objects should remain the same across a restore. It does on my test instance.

You can use a temp table to insert the data insert of selecting...

Two things, when you restore in SSMS

- Change the target db name

- Change the file names/locations.

As George mentioned the WITH MOVE clause does this in T-SQL. In SSMS, you need...

There will always be abuses. I don't think we ought to aim for a 100% correct solution. Mostly because I'm not sure what that would be.

However I think we ought...

I think lots do a good job. But there's no open-ness, or guidelines published. Each writer I hear talk about this on the radio uses a different set of rules....

I don't know how we fix this. You can have people report things to HR, but that often has repercussions. So many men overreact the other way when there is...