The dbf files are on the 98 machine and no other application uses those files.

All I do is just copying the files into a directory and then execute the...

OK, Thanks all for your great feedback 🙂

Hendry

well0549, Thanks very much for your helpful feedback. I found sp_ExecuteSQL useful too.

Now, I think I need to test all the version in any possible cases (as stated...

quote:

---

if I need to cascade a delete or update to another table I write triggers instead to handle this. These are ways...

I'm still curious about this

I rerun again the coalesce version and watch its execution plan carefully and indeed it uses the index. However, I'm really confuse...

Got it! Thanks again Guys

Hendry

shotofirish, Thanks for the resource. I may need it some time.

Hendry

simonsabin and Antares686, Thanks very much. Both of you enlightened me!

Hendry

jpipes, Thanks very much for the link. It's really an interesting discussion. Anyway, let me have a favor to ask you one question.

What's your primary goal for splitting up your...

Simon, Thanks for the link

simonsabin, thanks alot for your alert.

When I rerun the tsql under QA, I somehow noticed that your version was really making use of the indexes! Hmm.., I confuse why...

Klaas-Jan, Yeah I found the Coalesce version a bit faster too using QA

..but I'll do what Antares686 suggests. I need to test it. This is really what a Guru way...

Thanks NPeeters, that's what I needed (a step by step ref), I'll try to find that book.

Any other help?

Excellent!...but I'm just wondering what are the benefits of moving master db, tempdb, msdb (SQL system DB) from its default location? Is there anything deal with performance issue or something...

Don't forget that many high quality & top people from Oracle moved to MS and join up to build SQL Server (you'll see the next version will be a surprise...