so therefore, there really is 2 Indexes to this table? 1 for the Heap and 1 for the Primary Key(NONCLUSTERED INDEX)?

Having said that, if the heap Index is fragmented, do...

Naturally this Database will grow so the decision to copy the tables overnight to the SQL Server Database will be beneficial in terms of performance.

David Burrows,

70 Tables? The Database that...

I agree however, regardless of the platform, I would still have gotten the job as the Database that they require me to design is on on SQL Server 2000. I just...

I have just tested both options. Below are the stats.

Option                                             Duration

View                                       10 seconds

Copy table to SQL Server            300 milliseconds

In light of all this, I'm amazed at some of the CRAP platforms...

Ok. This could be an option. Thanks for that.

I will have to do some testing as PW has mentioned cross platform queries are typically slow. I'll give both options a...

and how do I JOIN to the Creditors table that resides on the SQL Server Database? CREDID is the Primary Key on both Databases.

WZ700,

It appears that OPENQUERY deos not support four-part names. Whether it's a view or four-part names or OPENQUERY, I have to join tables from 1 platform to the other which...

The data from Gupta can wait for 24 hours. So, your suggestion for a DTS Package overnight will work well.

I haven't asked the owners yet but I'm pretty sure that...

PROGEN is Gupta SQL Base Server.

If four part naming doesn't work, then how are you suppose to interact between SQL Base & SQL Server? A number of the queries I...

Assuming that this happening on the Enterprise Manager on your workstation, I would reinstall the SQL Client utilities on your workstation.

As for the Transaction Log option been disabled, check to...

Try rebooting the SQL Server first. Failing that, you will have to restore the MSDB Database! Thats assuming that you do have a good rescent backup of it!

I have done some investigation into this topic since I started this thread. Upon what I have researched in conjuction with the responses to this thread so far, we have it all...

Thanks PW. I forgot all about TOP.

Ok. I think of got it now.

So, is it fair to say that Normalization rules do not apply to surrogate keys?

Looks like I just have to accept what you are syaing as I do not understand what you mean by the "real primary key" is!

The Address Table has AddressID as...