Excellent article, thank you for providing a rationale for the gut feeling acquired when working with ORM developers.

Hi dwalker,

This is extremely interesting, and thanks for sharing.

I will try and find the time to look closer at this particular problem, as I had no idea that the speed...

Hi DEK46656,

You are absolutely right that there are many other ways of comparing data - I prefer SHA1 hashes, if possible in computed columns, myself. Here, of course, the accent...

Hi dwalker,

I have used MERGE succesfully on multi-million record tables - but, indeed, only when all the databases were on the same server. I use delta data detection techniques when...

Hi Al Kv,

Sorr if I was not very clear - any database can be used, as long as it contains the tables given in the script. I created an empty...

Excellent article - thank you

Hi Jonsathan,

You have good ideas there - cross-referencing columns with the same name and reusing repeatable descriptions. Thanks for sharing that.

Adam

Hi Charles,

I am using "Description" for a couple of reasons - firstly to show that you can classify metadata comments by your own categorisation types (I have used DataLineage, ToolTip...

Hi Toby,

The next (and final) article does indeed contain scripts to document a data dictionary, using the database metadata - let me know if you like it once it appears.

Regards,

Adam

Thanks Sanjay, I hope that the series proves useful.

Adam

Hi Patrick,

Thanks for the feedback, and you are quite right, this is the wrong image. I'll try & correct, but it might be a day or two...

All the best,

Adam

Nice one cjs - shows how much you can do with this - and in so many ways - when you try!

Hi Aigl,

I have never used extended properties in reporting services, so please share the knowledge if you get this working.

Also, as far as I know, you have to specify column...

Hi Danjam,

You are, of course, quite right about indexed views and standard version - thanks for correcting this.

Adam

Charles - have you looked at http://datadictionary.codeplex.com/ - free, and very good!