Non-trusted constraints

Non-trusted constraints and performance

Tibor Karaszi — Sat, 12 Jan 2008 16:51:31 GMT

(See my part 1 article about non-trusted constraints in general: http://sqlblog.com/blogs/tibor_karaszi/archive/2008/01/12/non-trusted-constraints.aspx

re: Non-trusted constraints

Alejandro Mesa — Mon, 14 Jan 2008 01:06:18 GMT

Hi Tibor,

It is always refreshing and educating reading from your blog.

First I want to add that you can use "DBCC CHECKCONSTRAINTS" to check the integrity of constraints in a table, before making them tusted.

Second, Hugo bloged about same theme long time ago in this same blog portal, so I wonder if there will be something new about trusted / non-trusted constraints, but I guess I will have to wait for the second part.

Can you trust your constraints?

http://sqlblog.com/blogs/hugo_kornelis/archive/2007/03/29/can-you-trust-your-constraints.aspx

Cheers,

AMB

re: Non-trusted constraints

TiborKaraszi — Mon, 14 Jan 2008 18:20:16 GMT

Hi Alejandro!

Thanks :-)

Ahh, yes, I intended to mention DBCC CHECKCONSTRAINTS, but it got lost in the writings.

I initially wanted to mention the smartness of removing a whole from a query (the join example), but while writing, I decided to mention a few words about non-trusted constraints. So that is what made it a two-part (and also me being too lazy to check for older such articles ;-) ).

re: Non-trusted constraints

Sameer Alibhai (SharpDeveloper) — Mon, 11 Jan 2010 15:03:30 GMT

I have seen non-trusted constraints used in the real world when you have some existing data (maybe from a 3rd party system or from a customer) that has been imported into your database that breaks some rules, and you cannot clean it up at the moment. However you still don't want your system to allow such data from the user interface. In that case you will add the constraint as non-trusted until you are able to clean up the data (if ever).

SQL Server : Comment rendre le serveur v??rifier toutes ses contraintes check ? | Partager du contenu

Wed, 15 May 2013 03:04:35 GMT

PingBack from http://www.rdhwwo.com/sql-server-comment-rendre-le-serveur-verifier-toutes-ses-contraintes-check/