http://blogs.msdn.com/b/bharry/archive/2011/05/31/growing-tfs-databases.aspxI’ve seen a few reports lately of TFS customers whose databases were growing very rapidly.&#160; After investigation, it has often turned out to be that they were uploading a lot of large attachments to TFS as part of their testing process and then noten-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/bharry/archive/2011/05/31/growing-tfs-databases.aspx#10174863Wed, 15 Jun 2011 15:22:31 GMT91d46819-8472-40ad-a661-2c78acb4018c:10174863Brian Harry MS<p>The reason is that these foreign key constraints impose significant performance overhead. &nbsp;Everytime you update a row, seeks must be performed to validate foreign keys and TFS is an unusually write heavy app. &nbsp;We take the approach of encapsulating our databases behind our middle tier (not allowing any untested access paths) and then testing our middle tier very thoroughly to ensure we never violate integrity. &nbsp;I&#39;m not saying that we NEVER miss anything but it&#39;s pretty rare.</p> <p>Brian</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10174863" width="1" height="1">http://blogs.msdn.com/b/bharry/archive/2011/05/31/growing-tfs-databases.aspx#10171649Mon, 06 Jun 2011 14:39:01 GMT91d46819-8472-40ad-a661-2c78acb4018c:10171649Alex<p>We reported this issue over a year ago. As a well as various TFS database integrity issues (this is the recent one: <a rel="nofollow" target="_new" href="http://social.msdn.microsoft.com/Forums/en-US/tfsbuild/thread/0f8ee76d-0ff5-424b-8170-235477762c9c">social.msdn.microsoft.com/.../0f8ee76d-0ff5-424b-8170-235477762c9c</a>).</p> <p>I kee pasking this question over and over again but get no answer: why does TFS database not enforce any data integrity (there is basically no foreing key constraints)?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10171649" width="1" height="1">