No, because running...

Correct, checkpoint writes dirty pages to disk to reduce the time required for database recovery should SQL restart unexpectedly.

Is the service started?

Don't use Task Manager to check SQL's memory usage, it shows incorrect values.

How are you identifying that the session 54 (which is your current session that you're running the sp_who from) is locking resources and preventing updates?

SELECT CHECKSUM(*) FROM StagingTable

Collisions are possible, so you'll have to do a column-by-column check over any matches, but should be faster. The main table can have a computed column with...

A backup is an extent-by-extent copy of the database. It cannot miss objects or take old versions of objects. What is in a backup is exactly what was in the...

That's because INIT deletes old backups from the file before starting the new...

You won't be able to do it in one go. You'll need to restore the database to SQL 2000 or 2005 first, then back it up and restore to SQL...

Was the backup overwriting the older backups in the file every night or appending the backup to the file?

Restore headeronly should show you what backups are in the file.

If there's...

If the object IDs haven't changed between SQL 2005 and SQL 2008, the system procedure is sp_MSenumchangesdirect (not that it helps much)

Let's rather focus on the two objects in database...

Eugh, traceflag 1204. I would strongly suggest you turn that off and put 1222 on in its place. Much more information...

You said

but I don't see anything...

I've often found that performance improvements attributed to index rebuilds are due rather to the stats updates that happen at the same time. I have on a number of occasions...

Brandie Tarvin (10/10/2013)

---

You might be able to get a single license for Scrivener that covers both the iPad and Windows version, then just transfer the files between devices. I don't...