More nolocks... I do hope your users are happy with potentially incorrect data. Nolock is NOT a go-faster switch.

See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

Probably the table variable. Up to 6 million rows in an unindexed table variable without stats = bad idea. Try a temp table or permanent table with a useful index.

Edit: SQL 2000....

The parameters are meaningless and never used.

The developers were smoking something.

Can't tell for sure, since you only posted part of the code, but the @Dummy parameter does nothing in the code you posted. Perhaps it's used elsewhere.

The 1 after the...

Mike Hinds (5/16/2013)

---

2) The weekly full backup is part of a multi-step maintenance job that also performs DBCC CHECKDB, index rebuilds, etc. It first performs a "Final" Log...

Mike Hinds (5/16/2013)

---

2) Schedule the log backups at a slightly odd start time (i.e. 12:01:35) so they can not run (and will not be running) when either the...

You need to do the usual testing to ensure that nothing in the app breaks on SQL 2008 R2.

SELECT INTO creates a new table and requires that the table specified in the INTO does not exist, hence I struggle to see how you've defined a trigger on a...

You can start by taking the nolock hints out.

See - http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

Unless, of course, all the users know and accept that the data returned by the query can be wrong and...

1, 2, 4, 5. Yes. (don't know about 3)

In that case, since it's a single text page, deleting the doc may remove the corruption (or may not). CheckDB with repair will just remove that one document

Why do you want to remove (Principal, Synchronised)? It's telling you that's the principal database for a mirroring configuration and that the mirroring is in the synchronised state (principal and...

The delete would probably fail.

Please run the following and post the full and complete output.

DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS