Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database ...

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 keeping them in the database.

SQL database is a relational database. The basic quality of NoSQL is that it may not require fixed table schemas, usually avoid join operations, and typically scale horizontally. Skip to primary ...