Jeff Moden (1/31/2008)

---

However, the engine has no obligation to scan the table in index order, as there are no language constructs which impose an ordering on the execution order of...

You can only have 1 primary key per table, but you can have many unique keys

Primay keys cannot have nulls. A unique key defined on a nullable field can have...

Matt Miller (1/31/2008)

---

I don't know about what your process is - but all of the built-in encryption functions, even the ones in 2005, are wholely inadequate for storing Credit card...

You could revoke all the table permissions and insist that all data access is via stored procedures. In the stored procs you can check the application name. You can also...

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...