Very likely.

Why?

Can you post the delete's execution plan? Also what are the waits you see for the delete?

Stale statistics perhaps? What happens if you update stats before running the delete?

I didn't look at it in detail.

Run it against a representative data volume, check the performance. If acceptable great. If not, identify which parts are slowest and ask for help...

More nolock abuse. Are the users aware and happy with the fact that their reports could return incorrect data?

Make sure you're restoring the same backup you took, not another within the same backup file if you're appending.

The only way you can do that is by using dynamic SQL or a string splitter function.

WHERE SomeCol IN (@Var) means WHERE SomeCol = @var

If a backup wasn't taken WITH CHECKSUM, then you can't use that option on the restore because there's no checksum to check. This is regardless of the database's page_verify setting.

No...

Never does. I suspect the attachment doesn't become permanent and hence accessible until post is clicked...

Jeff Brooks (12/11/2013)

---

I'm having trouble adding images to my posts. I've tried adding an attachment and referencing it but it doesn't seem to work. Instead of the image only an...

No, I was not. I was asking whether...

That's a formatting issue that should be dealt with in whatever application is reading this data.

bugg (12/11/2013)

---

I have considered this, but it will mean downtime to Enable READ_COMMITTED_SNAPSHOT ON, which unfortunately I cannot do anytime soon.

Also...

Have you considered one of the rowversion-based isolation levels?

Query, table definitions, execution plan please. Also, what are the wait types that you're seeing while the insert is running.