You'd have to read about performance tuning. Seeks are good, scans aren't. There are various performance tuning books out there, Ben-Gans is the best I think that can help...

I'mn not sure you can do this. There isn't a way to necessarily determine which table a column is coming from. Unless you have a way of determining which value...

I heard that in 2008 there will be rolling upgrades, meaning you patch the inactive node, failover, patch/upgrade the formerly active/now inactive node.

W2K8 is much different, but the rolling...

I believe they are triggered with an update to any row for that column. your code needs to handle which rows get inserted / updated in another table.

http://msdn.microsoft.com/en-us/library/ms186329.aspx

http://msdn.microsoft.com/en-us/library/ms187326.aspx

AFAIK, things are the same with the mail systems.

Posted a couple questions at MS. Are you keeping Windows the same? Is it 2003 or 2008?

How are you trying to connect?

The SAC is removed in 2008 and you need to sp_configured or use SSMS to make changes. If you are on the server, can you...

My guess is that 2008 will be very similar. The changes in 2008 are mostly add-ons from what I can tell and most of the same functionality in the core...

Encrypting everything in 2005 will cause issues. You can't index well. Think about whether you really need to index all the information or even most of it. If there's any...

I don't think there's a good overall tool.

No tool can discover all instances. There are too many ways these can be setup and configured. The best is a tool...

I'd look at the SPN and be sure you don't have timing issues (system time differences) between the two domain servers and the SQL server host.

What is getting updated? Are these columns not reachable from the web? Could people be entering bad data?

Are you only using stored procedures with ASP and the stored procedure object?

You...

Service account an admin? I think that was an issue in the past.

Please don't cross post. Answered here: http://www.sqlservercentral.com/Forums/Topic495330-338-1.aspx

This is an Enterprise only feature for 2008. That could change in the future.

Restore times should be much quicker, similar to backup time savings. Less reading from disk (slow) and...