Monthly Archives: June 2011

Duplicate Identity Values?

Can you have duplicate values in a field with the identity property? Of course, and this does it. DROP TABLE dbo.MyTable CREATE TABLE mytable ( id INT IDENTITY(1,1) , mychar VARCHAR(10) ) GO INSERT mytable SELECT ‘A’ INSERT mytable SELECT … Continue reading

Posted in Blog | Tagged , | Comments Off on Duplicate Identity Values?

The Care of Data

DBAs are supposed to be trustworthy. After all, they are the custodians of data and often have access to sensitive information because of the nature of their system administrator level privileges. Their turnover ought to be low, and hopefully they … Continue reading

Posted in Editorial | Tagged , | 2 Comments