... 检查页和结构的完整性——DBCC CHECKTABLE 检查约束的完整性——DBCC CHECKCONSTRAINTS 完整备份——BACKUP DATABASE ...
基于46个网页-相关网页
在ETL过程中，即时参照完整性和检查约束极其有助于检测数据问题，在最终的数据仓库表中实现它们也不会高效。
Even though referential integrity and check constraints are very helpful during the ETL process to help detect data problems, implementing them on final data warehouse tables is not efficient.
这一类的开销包括检查约束验证和外键约束(参照完整性(RI))验证。
This category of overhead includes CHECK constraint verification and foreign key constraint (referential integrity (ri)) verification.
应用推荐