Does it mean there's no tool to show that in diagram?:(

Actually no programmer is willing to review data model; unless they have to 😉 I think I'll refer to that...

Sure 🙂

hardware configuration: Win Server 2003 and I don't know more cause I don't have enough permission to get access to it

sql server version: SQL 2005 Enterprise Edition and SP1...

Thanks for your comments magarity kerns 🙂

I convinced my boss to not enforce any fk check between different DBs; FKs are created virtually (only DB designers know that col A...

Thanks anyway:(

🙂

Does it really support foreign keys between two different databases??:w00t: Then you're life saver 😛

I'll try the trial version but it takes me time to get my company's permission to...

Hey Charles your comments helped me much :w00t: Thank you 🙂

Thanks saggar!:)

Well... I agree with you but I'm just employed in this company and have to do what they ask (of course not always 😉 )

By the way, there's also something...

Hi again Jazemine

I was just trying the remote key and thought you may be interested in result:

though it sounds a nice tool at the beginning, since it's in its...

Thanks for the comments Jazemine and ALZDBA,

I'll consider the situation to make a better choice

forgot to say that the link is really useful Marios, thanks a lot

Any more comment or link is appreciated

Thanks all for the replies

We're having a number of applications with large DB and a number of indexes in each, which are not tuned for years and now causes systems...

Thanks for the reply Jazemine

However, Could you plz explain more? Maybe I do it for a short period of time to keep the performance high