Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » tips & tricks   (RSS)
1. Create FILESTREAM filegroup. 2. Add FILESTREAM column to table 3.   Choose one of: a. Write an app to select data from the BLOB column and stream it into the FILESTREAM column b. UPDATE <table> SET <filestream_column> = <blob Read More...
When using Filestream data in SQL Server 2008, you may come across what seems like strange behaviour. This is when you issue a DELETE statement to delete the filestream data, it doesnt actually disappear from the file system. You may ask…why is this? Read More...
 
Page view tracker