I would like to win the book, I find this really useful to delete duplicate items -

create table #T (identifier int, name varchar(100))

insert into #T select 1, 'Fred'

insert into...

When this has happened to me I have forgotten to deploy changes to the dimension before deploying the cube.