Good intro article. The next time if you can add larger data sets to query where there might be issues such as memory pressure, IO, etc. A...

The requirements should have been written into the document. If you're looking at state and federal level - the request for proposal might need to be rewritten. It...

Seems like you were working with inept management. If the vendor I'm working with doesn't trust their own work, I don't think I would be comfortable with them. ...

The use of file groups would allow you backup multiple portions of the database.

http://support.microsoft.com/kb/281122

This type of action might put more strain on network resources. So solving networking...

Mirroring is a bit easier in 2008 with the registry entry made for the failover by applications.