Jason-299789 (6/18/2013)
If you are adding a partition to the table or spliting a table into partitions that have data already, then you might want to run a DBCC to check the integrity once the split has occured and the data has been reassigned, only if you're paranoid or as a belt and braces check.
What exactly prevents the IO subsystem from corrupting said existing, static, read only data?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability