title: Adding a primary key to a large table on a shared database server
body: <p>I have a large database of zip / postal codes used in proximity searches. There are about 1 million records. Somehow I didn't add the primary key to the table, and now I have to add it because searches take about 3 seconds because of the full table scan. When I go to generate a script to add it in SSMS, the operation times out because it is creating a new table and important the data. Any ideas?</p>