@Werner

Not sure what you mean by

You can create a Lock / Semaphore / Mutex with...

To everyone who recommended the articles on dynamic SQL, thank-you. That is an elegant solution which I had missed due to my hard-wired "Dynamic SQL is Bad" thinking.

I also had...

Sad to think that SQL would fail to optimise when both FirstName and LastName are provided. I would expect it to use one Index and subselect the results.

Alternatively it could...

Nice. Helps if I remember that 6 > 5 :blush:

Always good to see a firm grasp of logic being used in computing!

If I may suggest a variation to this technique I have seen is to use ISNULL or COALESCE...

@Alen

The problem I am trying to resolve isn't so much that Job B must wait for Job A, and is dependant on the results of Job A. That...

So you are saying that buffer cache numbers should not be read in isolation? I am shocked! :ermm:

Yes, Page life expectancy is a factor, and that had already been covered...

97% buffer hit rate is decent. 3 reads out of every 100 are coming from the disk.

So in a large table with an index depth of 3, there will be...

BaddaBing (8/25/2010)

---

Due to budget constraints etc we've had to set up new database servers with 8 disk's (although I argued for more). I set them up as follows:

2 Disks on...

RAID 6 will survive only 2 disks failing

RAID 10 will survive up to 50% of the disks in the array failing providing that none of them are opposite sides of...

The resource should be checked in the environment where the stored procedure is executed. Server1 as that is explicitly where you have called the stored proc.

if you have multiple db...

@mishaluba

That's exactly the scenario I was looking to solve (and the problem of cleaning up these artifacts we create) while I was looking for this solution. When something happens and...

I only use this kind of thing where we are synchronising process that rely one thing to complete before another can start. I wouldn't use it to enforce transactional integrity...

I suspect the answer may be in your I/O subsystem, as various people here have commented that the CPU is not over-stretched and you are reported a 0 CPU Queue...

I'd agree with other posters that 8 drives is limiting.

Without having experienced RAID 6 I can't really comment on that.

I would go for a mixed setup.

Take 2 drives in RAID...