One thought I had was to move the files to a file server, then store their respective file paths in the database to link the files to the relevant data in the database. Its a fairly significant ...

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

Microsoft has just added support for query hints to Azure SQL Database, giving database administrators a powerful tool to manage the performance of ISV application code. Here's how it works.

Now, in SQL Server 2008, you have the best of both worlds with the introduction of the Filestream storage option. No longer do you have to make compromises.