http://support.microsoft.com/kb/899761

Again: *sample of the contents* , please ?

MERGE has been part of DB2 for a loooooonnnnggg time

Can you post a sample of the file contents ?

AND when doing "select *" you may be bringing more data than you intended if someone/somthind adds a column to the table(s) you are "select"ing from

Cheers,

check the fragmentation level of the indexes used in the queries and the statistics of the tables involved.

when creating the views you MUST specify an owner to get consistent ownership-chain.

Therefore you either type "dbo.viewname" when creating those or make the creator of the viwes the database owner...

Page level Locking is "ON" by default.

You should disable it only on *very rare* cases.

Nice SSMS BUG catch by the way !!!!

Dave,

I join your feeling. As far as I know there is no other way but dropping it and recreating it with NFR. I understand this is painfully done as...

exec sp_update_resume

Merge has been present in DB2 for years, it is a good thing that MS is catching up. Personally I find it handy for cetain things but I am afraid...

This is *very* helpful,

Thanks for sharing

you should also run UPDATE STATISTICS ...

You could either user triggers or calculated columns. If your data is comming through bcp a calculated column maybe the way to go otherwise triggers are ok, if you...