Mind sharing with us what you did? Not that I'd necessarily recommend anyone else follow your instructions from PSS, but I'm curious what might have been wrong and how they...

Actually it's an interesting question for an interview. If you have a lot of simple mode databases, then differentials could conceivably save you lots of resources on backups.

It's not crazy,...

Yikes, I appreciate your differences, won't discuss my beliefs, but no religion in the editorials!

Enjoy Christmas for what it's become: a holiday where we remember others and share goodwill with...

I'm getting slightly lost here, but I wanted to respond to Will a few posts above.

The problems with bad data are a good place TO require a PK, even a...

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...