Is data available for a partitioned table if one of the partitions isn't available? Instead of reading BOL, I wanted to test this. Here is an outline of what I did (you find TSQL code at the end of this post): Create a database over several file groups
Read More...