If you constantly run the optimizations and it grows the log to 13GB, why bother shrinking? It's just going to grow again. Leave it at 13GB. If you truncate it...

Have a series on how I used to do it.

http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart2.asp

http://www.sqlservercentral.com/columnists/sjones/vcspart3.asp

Are these related to SQL Server or just other services?

I don't think you want to put anything else on a SQL box if you can avoid it. Have competition for...

The inserts sound strange. Does the query plan give you an idea on where the reads are occurring? Are there perhaps triggers or extra keys on the slow system?

Backups are a problem. I remember in 94 we had an imaging system and we got to the end of our disks. They were large at the time and external...

My way of filling a Question Gets hard to think of new ones over and over. We're at about 1040 now.

Do you know when things changed? If so, you might be able to correct out some of the other data.

If you change the Windows system time, the SQL Server time...

http://www.sqlservercentral.com/columnists/sjones/batching.asp

Have you compared query plans on something that performs differently?

I think you want to manage schema changes so if you need to restore old information, you're covered.

Any scheme you come up with will have the possibilty of error. Or...

Wouldn't you need a placeholder for the first column in Excel?

SQL doesn't have the concept of a record, so finding the 2nd, 3rd, etc. occurrance is difficult. I'm not sure...

Is this an ASP error or a SQL error? You can grab information like @@error, @@error_description, etc. and send it back to the client from a stored proc.

If this is...

I agree with Scott on the function thing. I'd use a function as it would work well and I'd put the time zones in a table. You can use UTC...

check the filesystem or tape logs as well.

I'm not 100% sure, but I guess all DML statements are checked against triggers to see if they match. However the check doesn't create any load. If it does on...