One of the easiest ways to count reads is using profiler. Start up a session, trace T-SQL:Stmt_completed and/or T-SQL:BatchCompleted and filter on your login name and/or machine name.

It's a full table update, so the entire table has to be locked exclusively anyway until the update has completed, whether by a (forced) table lock or multiple row/page locks....

My mistake. I missed the TablockX hint. Replied without checking back to the article.

Edit: And even if the tablockX hint wasn't there, the statement in question is an update....

Than I'm stumped. Sorry. Maybe someone else here has an idea. If you're got a support contract with MS, consider logging a case with PSS.

I've had very bad experiences with...

TheSQLGuru (1/31/2008)

5) Enterprise Edition where you start the run while another scan is ongoing. The "join-along" capability of EE will jump on the existing read thread, then loop around...

Please in the future post schema, sample data and expected results. See - http://www.sqlservercentral.com/articles/Best+Practices/61537/

First question - is this homework?

You need a group by on classID and a max on...

Very nice, and thanks for the link.

What recovery mode is your database in? If bulk logged, are you doing any bulk operations (bcp, bulk insert, select into, index rebuilds)?

Are you asking how to shink the database and not the log? You'd do it by shrinking each of the data files individually.

Note Steve's warning above. You don't want to...

I'll have a go at it later this evening, if someone else doesn't reply first.

Very few situations. iirc the only time you want to consider fibres is whn the CPUs are spending a large portion of their time doing context switches.

A lot of stuff...

Subqueries in the select clause (corrolated sub queries) have a tendency to perform very, very badly. Unless the optimiser is really smart (generally only on simpler queries) the subquery can...

Linked server drivers use the MemToLeave area. I've had a case of a buggly driver leaking memory in MemToLeave and causing slow backups and eventually a system crash.

The thread stacks...

Adam Bean (1/29/2008) Two different SQL Server support techs informed me that issuing a DBCC DBREINDEX, ALTER INDEX REBUILD/REORGANIZE, will NOT update the statistics with fullscan. They recommended having a...

Looks good.