SQL Server priced higher than the competition? Are you speaking of another RDBMS? And if so, which one?

Or do you mean competition from other businesses?

If it works for you, I think you're OK. I don't know anything about that product, but if it's Raid protected and works, then it's a good idea. The...

1. Yes, no major issues I've seen reported here in 18 months since RTM.

2. The setup program for 2008 will do this. You can grab an eval, use a VM...

How much memory is on the box, what's the version / edition of SQL and Windows?

If there's nothing on the box, no reason, typically, to limit SQL Server. It caches...

The columns you use for indexes usually depend on your queries. The search arguments in the WHERE clause are were indexes come into play.

IF you create the first index and...

I've thought this for years, but when you...

john.w.walker (2/12/2010)

---

No, 2 days of full backups are not enough. There was a hack that made rounds 7-8 years ago that got everyone over a holiday weekend. At...

ZETM (2/12/2010)

---

This is something that just drives me nuts about some DBAs and some of the authors who and pretend that every byte of data in the world is somehow...

Congrats (just in case).

My word for the day is noise (kids off from school)

That's an image I can do without.

Each instance is completely separate, as though they were on separate machines. One cannot reference the other easily.

You can set up a linked server between the instances. It's not hard,...

You are welcome, but Michael brings up something I'd forgotten to mention. Maintenance is an issue. If you have an app (db) that is being patched/changed more often than others,...

You can always resize if you need it. If your tempdb is not growing often, you should be OK.

It's the growing that's an issue, not the size.

If this is the Microsoft DPM product, I think you need separate groups.

Doh was yesterday's.

Today is "so-close-to-the-weekend-I-can-taste-it"