Try using an Index on this column.

Also, if this table has a lot of inserts/deletes...i suggest u do a re-index every night.

Also depends if the table has an Identity column. If you need the identity column reset, i think you should be using TRUNCATE.

Correct me if am wrong!!

Did you try the ROUND function?