when you run this self joined queries I can expect that they are not particulary fast! but that is one thing and the other is that they KILL your server...

In some cases where "Parent" tables are large it may be a good thing to drop the foreign keys to perform TRUNCATE TABLE on ALL tables (if you need to...

You are welcome!

That is correct!! (The code was using Windows integrated security) The problem is that if you want to be able to switch "servers"  then you need to:

1. Setup account delegation with Kerberos (which...

Yeah I had to work late (on a personal project yesterday) and took a break to hop in for some break 😉 And you were online too!!!

Probably caused by your (# of posts)/s

Remi,

Yes you can use Openrowset:

Select *

into #T1

from Openrowset('SQLOLEDB','Trusted_connection=yes;Data Source=YOURSERVER','exec sp_who') dt

select * from #T1

drop table #T1

-- You need to have MSDTC ON and the server set to allow remote server connections...

This is tested (got SQL )

select SetVal

 , T1.NumSet1

 , (select Min(NumSet2) from  YourTable  T3

    where

    T3.SetVal = T1.SetVal

    and

    T3.NumSet2...

AGAIN this is without SQL in front of me I think I made a little mistake

select SetVal

 , T1.Numbset1

 , (select Min(Numbset2) from  YourTable  T3

    where

    T3.SetVal = T1.SetVal

    and...

Don't get me wrong they (cuban girls) are OK but not as open as you are

Forget about all that god stuff !!! I just...

If you have a logic to partition the values with a check constraint then the partitioned view schema is going to work for you. SQL will not scall all four tables. If...

I am not used to hear such compliments from a girl but given that is you I feel really flattered   and a...

You are welcome!

Well, every so often I have to go very near Virginia (Washington DC) so I may make a visit

I haven't testted this but give it a shot:

select SetVal

 , T1.Numbset1

 , (select Min(Numbset2) from  YourTable  T3

    where

    T3.SetVal = T1.SetVal

    and

    T1.Numbset1 > T3.Numbset1

    and 

    not...