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

Are you sure the data is the same between the servers? ORDER BY should work the same way, regardless of NULL values. Maybe the databases have different collation settings? That...

You should look at the OUTPUT clause. You can use that to capture the ID's generated for all the addresses you just inserted.