I have this exact same issue and I'm redirecting errors from an ado.net data source to a multi cast but I'm still getting blank values. Any ideas? I'm pulling from...

I have this exact same issue and I'm redirecting errors from an ado.net data source to a multi cast but I'm still getting blank values. Any ideas? I'm pulling from...

Okay, having a group of historical data logically separated into filegroups and data files makes sense.

We are partitioning because the table has a ton of data and will continue...

Switching the last partition in the 6 month filegroup to the archive filegroup will cause a complete index rebuild on the whole archive table? can i prevent that from happening?...