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

Content with tag data integrity Rss

   Items 1 to 7 of 7   
 

Check Candidate Columns for NOT NULL Constraints

This script reports table columns that allow NULL values but that currently have no NULL values, making them candidates for adding a NOT NULL constraint.  Read more...
By Charles Jacobus 2013/01/23 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 641 reads

Dropping a Row

How important is it that your server record all changes to every row? Probably very important and that is one of the foundations on which RDBMS platforms are built. Steve Jones talks about this being a difference with some NoSQL systems, and why it might not be acceptable to most businesses.  Read more...
By Steve Jones 2011/05/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 187 reads

Why is data integrity important?

Why should I care and why should the database enforce it? This article from Jamin VanderBerg gives some reasons why the database is the place to enforce rules that ensure integrity.  Read more...
By Jamin VanderBerg 2010/08/30 | Source: SQLServerCentral.com | Category: data integrity
Rating: |  Discuss |   Briefcase | 3,658 reads

Trust But Verify

As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.  Read more...
By Steve Jones 2008/11/19 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 103 reads

Trust But Verify

As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.  Read more...
By Steve Jones 2008/11/13 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 282 reads

Trust But Verify

As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.  Read more...
By Steve Jones 2008/11/13 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 291 reads

Handling Data Integrity Issues in Analysis Services 2005

Learn about common data integrity issues, and see how Analysis Services 2005 gives you the tools to handle them.  Read more...
By Additional Articles 2008/04/04 | Source: TechNet Blogs | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 1,558 reads
   Items 1 to 7 of 7   
 
Tags
election (3)    
editorial (2)    
analysis services (ssas) (1)    
cursor (1)    
dynamic sql (1)    
editorial - ipod (1)    
editorial - wmv (1)    
maintenance (1)    
nosql (1)    
referential integrity (1)    
system view (1)    
table variables (1)