You could insist that she adds OPTION (MAXDOP 1) to the end of each of her queries. Not ideal, but it might work.

You can use the governor that's in SQL...

No indexes and 2 million rows. Ouch. Does the table have a primary key?

I can suggest an index that is almost guaranteed to make this view faster. However, it's not...

Possibly someone formerly or currently on the dev team would know. There doesn't seem to be much available on the internals of statistics

Conor Cunningham[/url] indicated he might be writing on...

Please don't post in caps. It's the online equilalent of shouting, and it's kinda hard to read.

Could you please post the definition of the view, the schema and indexes of...

May I ask why you're interested?

In SQL 2005, all the implementation details of stats are hidden. On SQL 2000 it was possible to see the statsblob (an IMAGE column...

How about just

update header set Siebeltransnumber = CONVERT (char(6),h.trans_date,12)

+substring (h.trans_number, patindex('%[^0]%', h.trans_number), 20)

where Siebeltransnumber IS NULL

The reason you're getting errors is that SQL was trying to evaluate the subquery...

Placing hints without using WITH is deprecated syntax. SQL 2000 does allow hints to be placed without using WITH. SQL 2005 does not

Refer to OP's other post on this please- Reindexing and defragmentation (SQL 2000)

Apparently server is 2000, post was initially in wrong forum.

Can you post the update statement that you're trying to run?

Transactions by themselves don't cause locks or force locking modes. They just mean that a number of statements are treated like a single statement.

Temp table names don't clash with other...

If you're on SP2, use a login trigger. I've got one on my main server to prevent exactly this - users logging in using accounts they're not supposed to.

Short sample...

Spaceused can get out of sync with reality, especially on SQL 2000. I've had it reporting negative space used on a table.

Run DBCC updateusage on that index and see if...

If you need to do transactional replication, then you'll have to ensure there are primary keys on all tables you want to replicate.

Please don't cross post. It wastes people's time and fragments replies. Most of he regulars here read all the forums

Disscussions to the following thread please - Index size (Performance tuning)

Also the table schemas and index definitions would help.