A couple great questions came up last week when discussing FILESTREAM with some people within the Microsoft field which I thought were worth sharing.


Q: Will SQL Server 2008 Express edition support FILESTREAM?

A: It sure will!


Q: Will the 4GB limit of Express apply to data stored in the FILESTREAM?

A: Nope...  Go ahead and store large binary files!


As you may have noticed I'm really excited about binary data becoming a first class citizen in SQL Server 2008.  Once you dig into it I think you will agree.