There are some new events in Profiler/Trace to help with this. Otherwise, not sure there's a list. I'll post this around.

I'm with Grant. The DTA gives you a place to start, especially if you're not sure where, but I wouldn't trust it much beyond using it for suggestions that I'd...

This is 32bit, right?

I wonder if SQL Agent has a limitation. Keep in mind that Agent is a separate system from SQL Server. It's a different process.

Most of these products will probably deploy the same way you did, they'll send a script through to SQL Server.

There isn't a shortcut here. Not that I'm pushing you away...

The Inside SQL Server book is a great reference and it talks about this. There are in place updates, which just change the data in row, and there are updates...

Do you mean you are using SSMS to save the data?

This produces a text file and the CR/LF should be there.

There are some clustering videos at JumpstartTV as well:

http://www.jumpstarttv.com/channel.aspx?cat=4a00c49a-6207-4ba8-952c-807481629761

Look at PIVOT or a cross tab report.

It's not an easy thing to do, especially as what do you do with multiple rows? Are they extended to the right?

I'm not sure that there is a business reason to upgrade to 2008 from 2005. There aren't a lot of new features, and the new ones, for the most part...

The import/export wizard is designed to ad hoc import a file, not process lots of files. When you run the import/export wizard, you can build an SSIS package as the...

I'd really recommend that you begin learning SSIS and rewriting these packages.

We only send one copy of the newsletter to each email. If you are getting multiple ones on the client, we have seen this when the client sometimes has an...

I highly recommend books. Not because they're better than a web site, but because they help you get organized. They progress from topic to topic. Get one and go through...

I think Lowell has the answer. Without an ORDER BY, you can NEVER be sure which rows will be returned or deleted (or updated), but a TOP or SET ROWCOUNT...

If the databases have the need to share data, then it makes sense to consider one large database. I've seen separate applications that need to share data, but had separate...