Red-Gate has one that is pretty nice and reasonably priced - SQLCompare. I've got a review of it posted at:

http://www.sqlservercentral.com/columnists/awarren/sqlcomparereview.asp.

Andy

I dont think thats enough info to say. By starting databases you mean being opened? Do you have them set to auto close? Are you getting errors or just spotty...

Get both tables on the same server is probably your best bet. Replication might give you an easy way to manage this.

Andy

Can you verify that these are being correctly populated? Could some be null? Some kind of special char that delimits the array/extent?

MeatCost_1 = DTSSource("meatcost__1")

MeatCost_2 = DTSSource("meatcost__2")

MeatCost_3 = DTSSource("meatcost__3")

MeatCost_4 = DTSSource("meatcost__4")

MeatCost_5...

Trev,

You're saying that you would ALWAYS use a temp table if you needed to use a function in a join?

Leon's point is well taken as a way to optimize -...

Read the same thing...who knows.

Andy

Are you saying that there can be NO blocking with simultaneous execution of the same sp?

It is in the Backoffice Resource Kit (BORK) 4.5. I dont know if its available as a general download - if you're an MSDN subscriber you should be able to...

I've used the MS Load Simulator tool - it lets you run a script on a bunch of different threads from the same machine, variable interval and #active threads. We...

Gotcha. So what is the extent you refer to?

Im sure there is a cost associated with it - how much probably depends on which operation you're doing. I'd guess left is likely to optimize much better than right...

It depends. Indexing is pretty complex. Even if a single index by itself doesnt have good selectivity, it may work in concert with another index. Start by indexing all your...

I get the same error. I dont have desktop edition installed, I use Developer - not sure if that would make a difference. Found a Q note about the same...

Looks like it might be a service pack issue, take a look at this link:

http://groups.google.com/groups?hl=en&safe=off&ic=1&th=a0d89f024b92ca89,4&seekm=uocaRPEDAHA.224%40cppssbbsa02.microsoft.com#p

Andy

Im curious too - why do you have the repeating fields (meat1, meat2, etc)? If you're taking the time to move it to SQL, why not normalize while you do...