There are a couple of ways you can do this.

1. BCP the data out of one system into the other

2. Use Microsoft's import tool (which will let you work across...

I'm generally in favour of this idea, especially for the small to mid size businesses that don't necessarily need a full time dba or systems admin. And yes, you will...

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