K.. I'll be waiting .

can you use openrowset?

openrowset (correctserver, dbname, 'Create view...')

is this what you need?

=sum(x) / sum(y) ---make sure that the 2nd sum can't be 0

Maybe you should add that all the columns also included in the where condition/order by are also in the index. The goal of such a query is to avoid...

Yup... You can always print the statement if you just want to see it.

What was the problem?

What's the problem with the profiler?? The code being executed is the code you see there isn't it?

Example 1

Work performed: Rather than select * from a table, a developer takes the approach to only select the columns required in some SQL code, which is more efficient in...

I see your point. But this is still a problem I can't solve by blaming microsoft so I ignore that as a dead end non solution. As you...

Glad to know I'm not crazy .

I think this is the main problem at the moment. We already have many correct ways of making the model work, so why would we have to switch to this...

create proc dbo.DuplicateStuff @NextQuoteID as int, @CopyQuoteID as int

As

SET NOCOUNT ON

Insert into dbo.MyTable (QuoteId, Sector, Country) Select @NextQuoteID, Sector, Country from dbo.MyTable where QuoteId = @CopyQuoteID

SET NOCOUNT OFF

I still have to see a place where it's advantageous to split those 2 infos. Can someone think of an exemple where it takes less space and is faster...

Well my point is still this : I can't do crap about the quantity of tempdb per server... what else can I do? >> only good answer left :...

To follow Adam's thaughts, I read the question in this context :

Let's say my boss comes in screaming because the server is grinding to a halt suddenly. I...