The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob

  Tuesday, March 19, 2019

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

Microsoft EEC

  bob Links
Ignition switch barr...
There were more dances, and there were forfeits, and more dances, and there was cake, and there was negus, and there was a great piece of Gold Roast, and there was a great piece of Gold Boiled, and there were mince-pies, and plenty of beer. - Charles Dickens, A Christmas Carol
Wider View Insert

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
          CHECKDB With Data Pu...
          Displaying a trace o...
     User Management
     System Databases
     BCV
     Deadlocks
     Temp Tables
Windows OS

Insert Category

Will be added as a sub-category of, DBCC
CHECKDB With Data Purity

When upgrading from sql server 2000 to 2005, a dbcc checkdb must be run at least once with data_purity.

If an error occurs with the data_purity, these rows should be fixed.  Some fixes can be done by updating the data or by running dbcc updateuseage {table_name / index}, the error / message from checkdb will contain the table_name and/or index to run updateuseage with.