title: Fastest way to change column data type in SQL Server
body: <p>In SQL Server 2008, I have got a table of around 3 million records. I want to change the type of one of its columns from float to int. But seems it will take a lot of time. Is there any way to accomplish this very fast?</p>