Try taking a look at the PATH and ROOT options in the FOR XML clause.

You should be able to do this in a single select statement rather than 3...

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 one process...

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 would be...

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