you should have a baseline to know if performance is down:

http://www.sqlservercentral.com/articles/Administering/performancemonitoringbasiccounters/1348/

http://www.sql-server-performance.com/articles/per/hardware_tuning_performance_p1.aspx

From Microsoft, there will be lots of 2008 stuff they want to throw out. After all, they want you to upgrade.

The more popular authors might stick with 2005 since they...

The file shouldn't be open. Could there be some parallel/multithreading that grabs the file?

Can you get the FileWatcher from Sysinternals and see if the file is open when the second...

Sorry, but from your original post it appeared you wanted to consolidate those 3 old IPs to one new IP with the same port. That can't be done.

If you put...

Sorry, I was misremembering.

Here's the doc: http://technet.microsoft.com/en-us/library/ms345177.aspx, are the files in the same folder? Meaning that you've selected the folder where the maint logs are written? I'd double check someone...

I don't believe this will work since the restore physically is replacing pages. This isn't a logged operation AFAIK, because the log is being replaced as well. If this were...

You can't really autoincrement it. You can set a trigger to look at the updates and then set a value, but it could have concurrency issues.

Why not use an...

I thought the history cleanup task had to remove maintenance plan logs. Have you tried that task? I thought the maintenance task had limitations over which files it could remove.

Is...

Could the file be still open? Are both these processes running in SQL Agent?

Batching is good, but you'll need frequent log backups to keep the size down.

The other thing is to set the database into simple mode after it's in single user mode...

Check the errata for the book from the publisher's site. They write the MSPress books while things are in beta, so there tend to be some things in there that...

I think that SQL is fundamentally different than many other languages. Even more of a difference than Procedural->OOP, which was a hard transition for many people. Heck, many people haven't...

There is no easy way to do this. You can search information_schema.columns with a like '%birth%' and try to track down columns that contain that name. However if someone had...

I think the size is slightly dependent on the data and the algorithm. Since a varchar(15) doesn't really take any more space than a varchar(55), why worry? Set the size...

Perhaps you could share some code?

Table and clustered index and which data you think is where.