Did you actually read my previous replies?

I should also point out that strictly speaking, a Table is a logical structure/resource, and not a physical one.

This is important because although a physical resource can bottleneck...

You can partition the table to multiple different physical disks if you need to.

But this is an issue of Database Design, and NOT Data Design. Wherever possible, you should...

Agreed. If they're 90% the same then one table. If they're 90% different, then separate tables. But in the middle, there's some other choices also, like a...

Steve Jones - Editor (3/21/2009)

---

not really, a board is responsible for guiding the ideals of the company choosing a CEO. The CEO reports to shareholders. The board is elected by...

In any event, the answer to both questions is "It Depends"

#1 depends on how often you will use these 3 different vehicle types at the same time, versus how often...

In a many-to-many relation, such as described by these three tables, the maintenance of the Machines and the Brands and the BrandsinMachines must by done separately. You can combine...

Since I do a lot of my posting on the weekends, I have used the Posts Since Last Week quite a lot, and it has definitely changed in the last...

Then just add another file and let SQL Server manage this by itself. It will take care of it.

Hmm, the Avtive Threads problem is inconsistent, even in the same browser.

The Post Since Last Week, however, is consistent, even across browsers.

You can certainly do this with DBMail.

Plus, I would really think that you would want to use DBMail on SQL 2005 anyway.

I haven't done this in years, but don't you have to create the output table to hold the data first?

Glad I could help, Larry. Yeah, I wish BOL would mention this capability under the EXECUTE statement entry. You only know to look for it under INSERT if...

4 hours for this does not sound right at all. Can you provide a zipped copy of the XML so that we can test it?

Create a #temp table to hold the data, then INSERT.. EXEC to capture that output of the stored procedure calls.