Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tag CHECK constraints Rss

   Items 1 to 6 of 6   

Re-Trust Untrusted Foreign Keys and Constraints

This script will attempt to re-trust untrusted foreign keys and will report counts of successes and failures.  Read more...
By Shaun J. Stuart 2013/06/17 | Source: | Category: foreign keys
Rating: |  Discuss |   Briefcase | 648 reads

Query Tuning

By Jeff Moden 2011/12/27 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,079 reads

A Developers' Guide to Refactoring Databases

When Agile meets 'Big Design', the result can be frustration on both sides. Is it possible for database development to to easily coexist with Agile methodologies for application development? Nick suggests that the technical solutions already exist, and the dissonance is more due to cultural and organizational problems  Read more...
By Additional Articles 2011/05/04 | Source: SimpleTalk | Category: check constraints
Rating:  Rate this |   Briefcase | 5,544 reads

Check your Digits

The most persistent struggle in data processing has been to ensure clean data. There are many ways that data can be incorrect and a database must check, as best it can, that the data is correct. The CHECK constraint is ideally suited for this sort of work, and the checking routine can become quite complex when dealing with check digits in data.  Read more...
By Additional Articles 2011/04/28 | Source: SimpleTalk | Category: t-sql
Rating:  Rate this |   Briefcase | 2,985 reads

Fix Column Check Constraint Naming

This stored procedure can be used for applying a custom column check constraint naming convention  Read more...
By Michael S√łndergaard 2010/10/12 | Source: | Category: constraints
Rating: |  Discuss |   Briefcase | 507 reads

Using Check Constraints to Validate Data in SQL Server

A number of different processes that can be used to make sure your data validates against your business rules. This article discusses how you can use database "check constraints" to validate your data within the SQL Server database engine.  Read more...
By Additional Articles 2009/04/10 | Source: Database Journal | Category: check constraints
Rating:  Rate this |   Briefcase | 2,177 reads
   Items 1 to 6 of 6   
change constraint name (1)    
constraints (1)    
database design (1)    
foreign keys (1)    
implicit conversions (1)    
indexing (1)    
naming convention (1)    
sargability (1)    
t-sql (1)