Simply moving them to a seperate file will get you some, very moderate, performance gains, but moving them to their own disk will help a ton. But, it's still best...

One of these must be returning zero:

SUM(TotalMaterialValue) / SUM(TotalQuantityMade) AS AverageMaterialCost,

SUM(TotalLabourValue) / SUM(TotalQuantityMade) AS AverageLabourCost,

SUM(TotalOverheadValue) / SUM(TotalQuantityMade) AS AverageOverheadCost,

SUM(TotalTotalValue) / SUM(TotalQuantityMade) AS AverageTotalCost,

SUM(TotalTimeBookedMinutes) / SUM(TotalQuantityMade) AS AverageTimeInMinutes,

SUM(TotalTimeBookedHours) / SUM(TotalQuantityMade) AS...

You can use a variable on an insert, but there has to be a column to insert it into. You can't just throw it in as a placeholder.

And yes, it's...

I doubt there's an article out there comparing the two because they aren't really something you compare. Here's the BOL entry for max degree of parallelism and degree of parallelism....

Because you're working with 2000, this will be harder, but what you need to do is analyze the wait states and queues to figure out what you're slowing down on....

Brandie Tarvin (8/4/2010)

---

Grant Fritchey (8/4/2010)

---

Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with...

Complete agreement with Gail. Rather than knock yourself about moving the index locations (you just have to recreate the indexes and reference the new file or filegroups using the ON...

No, you can't do that. Not that way. A variable is just a place holder and is not resolved into TSQL on the fly. What you can do, and I...

Jeff Moden (8/4/2010)

---

Grant Fritchey (8/4/2010)

---

The max degree of parallelism and having multiple files for your tempdb are not directly related. One has to do with file storage, the other has...

Brandie mentioned SSIS, which is SQL Server Integration Services. It's the built-in SQL Server ETL (Extract/Transform/Load) tool. She was suggesting that if they could deal with day old data, to...

The max degree of parallelism and having multiple files for your tempdb are not directly related. One has to do with file storage, the other has to do with how...

If they need live access you just have to set up a connection either direct through ADO (or whatever) or using another tool such as the Oracle Gateway (it used...

DealerID is being supplied from the original file, right? That's where you get it. Presumably you can join back to the original file with the address information to get the...

Steve Jones - Editor (8/3/2010)

---

Jack Corbett (8/3/2010)

---

WayneS (8/3/2010)

---

Well, since Steve asked for opinions on one topic, let me broach another topic.

What do you'll think about this[/url]? Is there a valid...

It is possible, just thinking about it, for the NULL values to mess you up though. An ORDER BY statement that is working on NULL values could get those values...