I wouldn't rely much on the order of triggers. Rather have it in one.

You have first, last, and between (with no order)

not as versatile

select MustHave.candidateid,NiceToHave.Extras

from

(

select candidateid

from  dbo.Candidate_Qualifications Candidate_Qualifications

where qualificationid = A

OR qualificationid=B

OR qualificationid=C

group by candidateid

having count(QualificationID)=3 /*COUNT 3 = have A,B,C*/

) AS MustHave

left join /*All of musthave, Nice to have if...

I would save your changes in the local dataset, and modify the insert/update/delete commands of the dataset to use your stored procedures to insert/update/delete.

and SPID 10 is?

Database master: IO is frozen for snapshot

= start of taking a snapshot

Database master: IO is thawed

= taking of snapshot finished. (?)

Is there replication on the server?

You're welcome.

Every time I had this error it was related to one of the tables not having a primary key.

The xeons have the hyperthreading-feature. Each processor presents itself as a dual-processor to the operating system.

Mostly an on/off switch is provided in the bios.

An article about hyperthreading:

http://www.digit-life.com/articles/pentium4xeonhyperthreading/

I'll search for new drivers, biosses.

Thanks for suggestions.

Does it happen at regular intervals, specific times?

Perhaps some program is inserting/retrieving lots of fresh data or using not everyday queries?

Buffer cache hit ratio is related to memory.

Might be completely unrelated, but when a particular printer mentioned an error it caused to block all tcp/ip sockets, resulting  in communication link failures, no internet ...

A thing that helped was...

What processors are there in your Dell system?

It could be hyperthreading (like Pentium 4 does)

If I read this correctly

H1 gives a list of products identified by species.ID and producttype

D1,D2... gives the amount of a specific size

and you want it presented in 1 line species...

You can implement the log shipping using sql-scripts

Backup database 1, restore to other in Standby mode (with standby or normally)

Backup log database 1, restore to other (with standby or no recovery)

Backup...

1) Why aren't you using

AND pb.SalesText like 'A%'

instead of

CONTAINS(pb.SalesText, 'A*') ORDER BY SalesText, VendorName

No need for the fulltext indexing and uses a regular...