Thanks for the note, and I'd love to know how it works out. If you can grab some metrics now, and then some later, I've love to see a writeup...

I tend to be with Perry. There are ways that software can handle the imaging, and 4 hours seems long. But overall, I wouldn't build a VM, and a non-VM...

If you use the Configuration Manager, it should assign all rights SQL Server needs to the account. If you've moved anything, or you use non-standard folders for things like backup,...

I'd choose #1, but I'm conservative, and tempdb gets written to a lot, so I'd be worried about failure.

With the four files, one filegroup? Depending on your workload, you might...

Here you go, pie chart:

john.arnott (1/23/2012)

---

Re: Moneyball....

The lessons applied were not just in talent evaluation, but also tactical decisions while playing the game. Statistical analysis showed that outs are often under-valued and so...

I never merged w/ DB objects.

The Red Gate tool can help (disclosure: I work for RG), but it doesn't necessarily do all this. It's just an interface to the tool.

The...

It's close to the book, but there's much more in the book.

In terms of...

You are welcome, good luck, and if you have more questions, post away.

I'm not quite clear what you mean?

The two applications don't matter if they're sharing the same data. You just have code and tables, and you call what's appropriate from each...

I think what's confusing is you say "separate 1 for the data, and 1 for the code/engine", but you say 2 applications. So are you proposing, or dealing with:

db1

- data

db2

-...

We have a "join the discussion" link at the bottom already.

I suspect we need to come up with something else.

Let's do the time warp again.....

Just generated a new Win XP key. Feels strange.

If that's the reason, two apps, use schemas or something else. Having it in two databases isn't providing performance gains, and potentially this is a greater administrative headache.

I've seen this in cases where you have multiple clients and want to separate their data, but the code is all the same.

However when I've done this, I usually use...