That's not a bad question. It will get you an idea of how people think.

You are welcome, and I'm less concerned about support these days. The products are fairly mature, and most of the issues are raised in the first 18 months. As of...

A lot here, but let me help.

Downtown Seattle isn't that large. Lots of hotels that are < 5 minute walk to the convention center, but most are in the $150-200...

XML imposes a lot of overhead, and so many systems are built on relational data, not XML. If you've bought into a solution and use it extensively, it will work...

Ben,

Well said, and I tend to agree. The lack of TDE being in other editions, as well as a lack of protection for backup files is an issue.

The remote access...

Not being able to backup/restore a snapshot, is, IMHO, a big hole.

I submitted a connect item on it: https://connect.microsoft.com/SQLServer/feedback/details/533288/allow-backup-restore-snapshot-databases

Iain has the idea. The call doesn't want a function as a parameter. You need to assign it first.

Seems silly to me, but probably some technical reason that doesn't seem...

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