My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/Blobs block online indexing
The new RSS feed is here
If you are lucky enough to be running enterprise edition
of SQL you may have looked or want to look into online index rebuilds.
Unfortunately having blobs in your index blocks you from being able to do online
rebuild of that index. Cruically what that means is that if your table is
clustered then you cannot rebuild the clustered index on that table
... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/Blobs block online indexing