I don't understand what multiple tempdb data files have to with memory usage.

Can you explain in more detail what's your issue exactly?

CREATE TABLE #TestTable (

Debt money

)

INSERT INTO #TestTable (Debt) VALUES (1)

INSERT INTO #TestTable (Debt) VALUES (2)

INSERT INTO #TestTable (Debt) VALUES (3)

ALTER TABLE #TestTable ADD TestColumn AS 'You owe $ ' +...

SQLCompare will do the trick.

It's a great product.

Columns to rows looks like a good fit for UNPIVOT.

However, I don't understand the expected output.

Can you please post your question according to the specs in this article[/url]?

Sorry, I'm a bit confused.

If I understand correctly, the new publisher displays a wrong distributor, right?

Change the distributor using sp_adddistributor. See here for more detail.

Hope this helps

Gianluca

If you can afford some downtime, the simplest way to do this would be a backup/restore with move to the new storage. Detach/attach would do the trick as well.

Another option...

If the code was not changed, you should check if the physical structures changed. I mean you should look at the indexes and stats on the table(s).

Also, make sure you're...

Send the e-mail from within a trigger.

Use the INSERTED logical table to capture the new records only.

Hope this helps

Gianluca

OH! I think I'm the main culprit for this thread. 🙂

I say 2c because it's both my opinion and what it's worth. During the last few years it has become...

You mean "logical" backups (imp/exp), I suppose.

Dev (11/23/2011)

Can you please lead me to some evidence?...

I would be very surprised of the contrary.

@dev: try it...

Good points, but you can achieve the same with schemas as well.

You...

It's an I/O intensive operation, so I guess it will affect the whole server.

Can you post the command you tried?