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

As a compromise, you might prefix things with sp only, as in spMyProc. This doesn't cause the performance issues.

Or you could do uspMyProc, which is something I've seen. A short...

You can monitor fragmentation with dbcc showcontig and then based on the results, decide which indexes you want to rebuild. Lots of scripts here on the site.

Other than that, SQL...

You need to create a connection on Server A, then perform the backup using this connection.

An ActiveX task is needed to perform the copy. The FileSystemObject in VBScript is probably...

The IP doesn't matter. SQL Server will bind to the host's ip.

The name does matter. You need to run

sp_dropserver

sp_addserver , local

and then restart SQL server.

Good points.

Either book is fine. I'm partial to Brian's book, but he's a business partner of mine, so I tend to use his resources.

I'd also look at sqlis.com