Yeah. Get rid of the cursor. I can't see anything that makes the cursor necessary.

Some information on what it's supposed to do, structures of tables involved and...

Try doing a save-as

http://download.microsoft.com/download/f/1/c/f1cf7b8d-7fb9-4b71-a658-e748e67f9eba/RowVersioningBasedIsolation.doc

I've greatly enjoyed this thread, and a...

Jonathan Kehayias (7/15/2008)

---

The key thing here is the timing of the events. In this kind of deadlock scenario, a few nanoseconds can make the difference between a successful execution...

Do you have replication active?

Do you have database mirroring?

If you run the following, what does it return for the DB in question?

SELECT name, recovery_model_desc, log_reuse_wait_desc from sys.databases

Since it's training courses and lab...

There's no magical quick-fix for performance problems. You are going to have to find the poorly performing queries (run profiler for an hour or so and catch all the queries...

What recovery model is your database in?

The concatenation problem I'll leave for someone else. As for the perf problem...

The functions you have on the column in the where clause prevent index seeks, so the query requires...

Specifying WITH RECOVERY recovers the database and brings it online. Once recovered, no more log backups can be applied (which is why you only want it specified on the last)

Then someone's running a proc/sql batch on the other server that's checking your statistics.

Have a look at the server that's the source of this. See what you can see running

Reindex alone should be fine. Reindex updates the statistics so there's no need to do that as a separate step

Don't shrink your databases

Don't truncate your logs. Either set up a...

I thnk that's an ODBC function, rather than native SQL. Can't find a confirmation though.

Either way, there's no associated...

DBCC SQLPERF(logspace) will show you the percentage log space used for all the database on the server

On which version of SQL? On SQL 2005,...

Entries disappear from the query_stats DMV when the query plan is discarded from the plan cache. Depending...