There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...

tl;dr - see last paragraph. trying to design a generic file attachment table(s) for some business objects we keep in sql 2008 r2. files will be stored on disk and i'm not really interested in ...