If you want to learn SSIS, and it is worth the investment in time, you could do all of this in there and implement complex rules for handling this.

However Sergiy...

Very interesting. If you change it back, does it slow down again? Be interesting to know. Sounds like some kind of bug, but not sure it's worth chasing down.

If you have SP2, you can set this in the Maintenance plan cleanup.

Use .bak, the standard extension. SQL Server will find the backups.

Nice list! Want to write us an article on this?

Steve

How is a unique index defined and used as a PK handled in code? I'm slightly confused as to what they are doing in code? Does Oracle not define PKs...

A one row table is interesting. Perhaps that makes sense, but really I'd define a PK anyway. Never know when you'll add another row for some reason.

Robert H, you've got...

Re-reading this, I'm wondering what the purpose of your transfer is? Is it going to be accessed as a reporting database? Or is it backing the an SSAS cube? Is...

You would have to default your schema to the new one. By default in SSMS, you create schemas in your own schema, which probably defaults to dbo.

Use SQL statements to...

Please don't cross post.

First thread here: http://www.sqlservercentral.com/Forums/Topic431539-1042-1.aspx

The HTML display in Outlook is based on the size of the area in which it's displayed. This doesn't necessarily match what's printed, which is a problem.

Are you saying a...

Is it running on the same client in both cases? If not, you have two choices, client or server potential issues.

You could have a different isolation level on each server...

You can query for the licensing mode: http://blogs.msdn.com/sqlblog/archive/2006/11/10/tracking-license-information-in-sql-2005.aspx

I'm not sure why the product key was filled in. Possibly someone set up an unattended install and burned that to the media....

Do you get a similar error in the SQL Server error log?

This can happen at times when the server becomes overloaded. Is this standard edition of SQL Server? The reason...

Can you explain what isn't working in the backup and restore? This is a lot to look through and I don't see anything obvious. Does it not perform the log...

I would agree with Michael above. You should not change MAXDOP or depend on any ordering of the records for any reason. It isn't the way SQL is designed to...