what are you trying to do? This is such an open ended question, it's hard to answer.

SQL Server 2005 has data encryption features, but you want to be careful about...

If you have moved all services to their own network accounts, then this should not be a problem. Each service runs under the context of the service account, or under...

No, you have two constraints with different names,

Each instance requires its own IP. You can set those in the Configuration Manager.

However, you should be very careful about exposing 1433 to your public side. A report last week...

Check the links and is there a point to what you are asking? Meaning why do you need to know?

If it's curiosity, there's a lot out there to read about....

If you use one of the third party backups, LiteSpeed or Red Gate Backup, they might do object recovery for you (depends on version). SQLCompare from RedGate, does comparisons from...

What I'd first recommend is that you get a list of queries that are run often and then search through those to see if you can improve their performance. You...

Keep the log and data together if you don't have another volume. You want them protected.

The error has nothing to do with log and data files. It sounds like the...

I don't and a few searches haven't turned up anything. Have you tried the backupdevicecollection.

Or maybe one of the restore classes? That might grab the data from the backuphistory tables.

I think that's the best approach and thanks for the update.

Actually I tend to postfix so I can group similar functions together. I want the

uspSalesGetforQuarter

right next to the

uspSalesGetAllforSalesman

As opposed to

uspGetAllSalesforSalesman

uspGetAllProductsforCustomer

...

uspGetSalesforQuarter

I've found that it's pretty easy to identify the major...

OK, you have 3 large questions and I'm not sure about #2. Need a BI/SSAS person to answer or give hints. I will say that you need to determine if...

SQL Server 2008 will have things built in to help ensure that the files are synchronizes with the data, they can be backed up, but also queried with T-SQL.

There is...

In a cluster, each individual instance needs to be reset if those host names are changing. They will bind to the IP of that server.

If the IP of the virtual...

Yes, as far as checking to see if indexes are being used, you can use the DMVs so see what's being used.

This blog post can help: http://blogs.msdn.com/sqlcat/archive/2006/02/13/531339.aspx