Can I split a single SQL 2008 DB Table into multiple filegroups, based on a discriminator column?
- by Pure.Krome
Hi folks,
I've got a SQL Server 2008 R2 database which has a number of tables. Two of these tables contains a lot of large data .. mainly because one of them is VARBINARY(MAX) and the sister table is GEOGRAPHY. (Why two tables? Read Below if you're interested***)
The data in these tables are geospatial shapes, such as zipcode boundaries.
Now,…