As far as I am aware no but they both have have a concurrent workload governor that limits the performance of the database engine kind of like those governors in...

You are limited to 2GB total.

This is purely off the top of my head but wihtout using temp tables or cursors the way I would do it is to add another column, an identity column...

Ideally the log should be on a mirrored drive as you cannot afford to lose it and the activity on it will be mostly writes. The data files may have...

For the guy doing the VB exams. They ask you a lot of stuff you may only ever need to know except for the exams (VB 6) so don't rely...

aggrevating aggregation

Use getdate() function on an update trigger for the table to populate your lastupdated field and don't make the 2 columns visible in your view.

SELECT * FROM

(select Siteid as Vessel,callid,sum(airtime) as total_minutes into tempweek from oldbill02 with(index(siteid)) where callwhen >='12/31/2002' and substring(callnbr,5,3)<>'976' and siteid<>' ' ) as A

UNION

SELECT * FROM

(select Siteid as...

quote:

---

select Siteid as Vessel,callid,sum(airtime) as total_minutes into tempweek from oldbill02 with(index(siteid)) where callwhen >='12/31/2002' and substring(callnbr,5,3)<>'976' and siteid<>' ' group by siteid,callid

...

Not quite the intent shared prevents updates or deletes by another transaction but you can still read the rows.

If you select is for a report or something else that just needs to unrepeatable reas at thae point in time then use a NOLOCK hint in the select statment...

quote:

---

An intent lock indicates that SQL Server wants to acquire a shared or exclusive lock on some of the resources lower down...

Any suggestions on the best approach to tackle such a situation if you inherit it?

Is there anyone out there at the other end of the scale. With a live constantly evolving production system with next to no comments and no documentation? Yes I know...

Another good reason for braking the task into chunks is in case of rollbacks. If you perform the delete in one big chunk and are unlucky enoough to have to...