Id agree - newid() is a performance killer.

its much faster to do something like this...

DECLARE @RandomNumber float

DECLARE @RandomInteger int

DECLARE @MaxValue int

DECLARE @MinValue int

SELECT @MinValue = MIN(Id),

...

We have similiar issues here with the use of *, espically with young developers.

As all our DB projects are under source control, ive been able to control checking in SQL...