What is SQL Server FILESTREAM and when should it be used?

FILESTREAM stores large binary data in the file system while maintaining transactional consistency.

FILESTREAM integrates SQL Server with NTFS to store BLOB data outside the database while preserving transactional integrity. It is useful for large files like images or documents, improving performance compared to storing them in VARBINARY(MAX).