SQL Server Performance

TSQL to list of all foreign keys and their respective tables

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Jul 13, 2010.

  1. Anonymous New Member

    Not that every time I recommend to disable any constraints on the database, but there are times when you may need to temporarily relieve the referential integrity checks of one or more foreign keys, such as when you're performing a large number of inserts and updates on a series of tables and want more accurate results and better performance. Obviously I have gone through the process within a test platform to ensure no issues for live data, and a quick requirement to disable foreign key constraints....(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2010/07/13/9287.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=9287" width="1" height="1">

Share This Page