As I said, if the column is varchar and the string literal is NVarchar (as in your slow examples), the...

Hang on.

You're backing the transaction log up every 15 min, writing to the same file and specifying overwrite? Is that correct?

Why full backups ever 2 hours? That's awfully frequent, especially...

Did you check the syntax of the RESTORE command in Books Online? Like backup, there can be...

Schadenfreude-Mei (4/24/2009)

---

1. The log grows to the extent whare it cant be backed up in the windows between backs (the log is backed up every 15 minutes but takes 20...

Take it offline. If you make the DB single user there's a chance that someone will grab that single connection before the restore starts.

ALTER DATABASE MyDB SET OFFLINE WITH ROLLBACK...

Please ask your DBA to run the upgrade advisor on the database that you want to upgrade. It will pick up most (as I recall) of the issues.

Also see here...

Mind...

If you want to split a backup over two devices, you can specify 2 (or more) destinations and the backup will be striped across those. Note that you need all...

Unless you had a trace running when that happened, I don't believe there's any way to find that information.

Have you run the SQL 2005 upgrade advisor?

Can you post the update statement and the trigger code please?

http://sqlinthewild.co.za/index.php/2008/07/08/what-is-a-deadlock/

As for timestamp, have a look in Books Online. There's a lot of info on timestamp there.

No, not at all.

DROPCLEANBUFFERS, as it's name says will...

Normalisation?

http://www.sqlservercentral.com/Forums/Topic703573-149-1.aspx

It's all yours. I'm headed for bed.

Sample data?

Desired output?

Regarding normalisation, read these -

http://msdn.microsoft.com/en-us/library/ms191178.aspx

http://en.wikipedia.org/wiki/Database_normalization

http://support.microsoft.com/kb/283878

http://www.databasejournal.com/sqletc/article.php/1428511/Database-Normalization.htm